ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,546 rows where county = "Williams" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501639 | 2501639 | 2022-05-13 | Williams | North Dakota | 38105 | 10496 | 68 |
2501730 | 2501730 | 2022-05-13 | Williams | Ohio | 39171 | 9090 | 164 |
2498381 | 2498381 | 2022-05-12 | Williams | North Dakota | 38105 | 10488 | 68 |
2498472 | 2498472 | 2022-05-12 | Williams | Ohio | 39171 | 9090 | 164 |
2495123 | 2495123 | 2022-05-11 | Williams | North Dakota | 38105 | 10488 | 68 |
2495214 | 2495214 | 2022-05-11 | Williams | Ohio | 39171 | 9055 | 164 |
2491865 | 2491865 | 2022-05-10 | Williams | North Dakota | 38105 | 10488 | 68 |
2491956 | 2491956 | 2022-05-10 | Williams | Ohio | 39171 | 9055 | 164 |
2488607 | 2488607 | 2022-05-09 | Williams | North Dakota | 38105 | 10488 | 68 |
2488698 | 2488698 | 2022-05-09 | Williams | Ohio | 39171 | 9055 | 164 |
2485350 | 2485350 | 2022-05-08 | Williams | North Dakota | 38105 | 10488 | 68 |
2485441 | 2485441 | 2022-05-08 | Williams | Ohio | 39171 | 9055 | 164 |
2482092 | 2482092 | 2022-05-07 | Williams | North Dakota | 38105 | 10488 | 68 |
2482183 | 2482183 | 2022-05-07 | Williams | Ohio | 39171 | 9055 | 164 |
2478834 | 2478834 | 2022-05-06 | Williams | North Dakota | 38105 | 10488 | 68 |
2478925 | 2478925 | 2022-05-06 | Williams | Ohio | 39171 | 9055 | 164 |
2475576 | 2475576 | 2022-05-05 | Williams | North Dakota | 38105 | 10484 | 68 |
2475667 | 2475667 | 2022-05-05 | Williams | Ohio | 39171 | 9055 | 164 |
2472319 | 2472319 | 2022-05-04 | Williams | North Dakota | 38105 | 10484 | 68 |
2472410 | 2472410 | 2022-05-04 | Williams | Ohio | 39171 | 9031 | 164 |
2469063 | 2469063 | 2022-05-03 | Williams | North Dakota | 38105 | 10484 | 68 |
2469154 | 2469154 | 2022-05-03 | Williams | Ohio | 39171 | 9031 | 164 |
2465807 | 2465807 | 2022-05-02 | Williams | North Dakota | 38105 | 10484 | 68 |
2465898 | 2465898 | 2022-05-02 | Williams | Ohio | 39171 | 9031 | 164 |
2462552 | 2462552 | 2022-05-01 | Williams | North Dakota | 38105 | 10484 | 68 |
2462643 | 2462643 | 2022-05-01 | Williams | Ohio | 39171 | 9031 | 164 |
2459296 | 2459296 | 2022-04-30 | Williams | North Dakota | 38105 | 10484 | 68 |
2459387 | 2459387 | 2022-04-30 | Williams | Ohio | 39171 | 9031 | 164 |
2456040 | 2456040 | 2022-04-29 | Williams | North Dakota | 38105 | 10484 | 68 |
2456131 | 2456131 | 2022-04-29 | Williams | Ohio | 39171 | 9031 | 164 |
2452784 | 2452784 | 2022-04-28 | Williams | North Dakota | 38105 | 10480 | 68 |
2452875 | 2452875 | 2022-04-28 | Williams | Ohio | 39171 | 9031 | 164 |
2449528 | 2449528 | 2022-04-27 | Williams | North Dakota | 38105 | 10480 | 68 |
2449619 | 2449619 | 2022-04-27 | Williams | Ohio | 39171 | 9016 | 164 |
2446271 | 2446271 | 2022-04-26 | Williams | North Dakota | 38105 | 10480 | 68 |
2446362 | 2446362 | 2022-04-26 | Williams | Ohio | 39171 | 9016 | 164 |
2443016 | 2443016 | 2022-04-25 | Williams | North Dakota | 38105 | 10480 | 68 |
2443107 | 2443107 | 2022-04-25 | Williams | Ohio | 39171 | 9016 | 164 |
2439760 | 2439760 | 2022-04-24 | Williams | North Dakota | 38105 | 10480 | 68 |
2439851 | 2439851 | 2022-04-24 | Williams | Ohio | 39171 | 9016 | 164 |
2436504 | 2436504 | 2022-04-23 | Williams | North Dakota | 38105 | 10480 | 68 |
2436595 | 2436595 | 2022-04-23 | Williams | Ohio | 39171 | 9016 | 164 |
2433248 | 2433248 | 2022-04-22 | Williams | North Dakota | 38105 | 10480 | 68 |
2433339 | 2433339 | 2022-04-22 | Williams | Ohio | 39171 | 9016 | 164 |
2429992 | 2429992 | 2022-04-21 | Williams | North Dakota | 38105 | 10472 | 68 |
2430083 | 2430083 | 2022-04-21 | Williams | Ohio | 39171 | 9016 | 164 |
2426736 | 2426736 | 2022-04-20 | Williams | North Dakota | 38105 | 10472 | 68 |
2426827 | 2426827 | 2022-04-20 | Williams | Ohio | 39171 | 9006 | 164 |
2423480 | 2423480 | 2022-04-19 | Williams | North Dakota | 38105 | 10472 | 68 |
2423571 | 2423571 | 2022-04-19 | Williams | Ohio | 39171 | 9006 | 164 |
2420223 | 2420223 | 2022-04-18 | Williams | North Dakota | 38105 | 10472 | 68 |
2420314 | 2420314 | 2022-04-18 | Williams | Ohio | 39171 | 9006 | 164 |
2416968 | 2416968 | 2022-04-17 | Williams | North Dakota | 38105 | 10472 | 68 |
2417059 | 2417059 | 2022-04-17 | Williams | Ohio | 39171 | 9006 | 164 |
2413712 | 2413712 | 2022-04-16 | Williams | North Dakota | 38105 | 10472 | 68 |
2413803 | 2413803 | 2022-04-16 | Williams | Ohio | 39171 | 9006 | 164 |
2410456 | 2410456 | 2022-04-15 | Williams | North Dakota | 38105 | 10472 | 68 |
2410547 | 2410547 | 2022-04-15 | Williams | Ohio | 39171 | 9006 | 164 |
2407200 | 2407200 | 2022-04-14 | Williams | North Dakota | 38105 | 10470 | 68 |
2407291 | 2407291 | 2022-04-14 | Williams | Ohio | 39171 | 9006 | 164 |
2403944 | 2403944 | 2022-04-13 | Williams | North Dakota | 38105 | 10470 | 68 |
2404035 | 2404035 | 2022-04-13 | Williams | Ohio | 39171 | 8999 | 164 |
2400689 | 2400689 | 2022-04-12 | Williams | North Dakota | 38105 | 10470 | 68 |
2400780 | 2400780 | 2022-04-12 | Williams | Ohio | 39171 | 8999 | 164 |
2397434 | 2397434 | 2022-04-11 | Williams | North Dakota | 38105 | 10470 | 68 |
2397525 | 2397525 | 2022-04-11 | Williams | Ohio | 39171 | 8999 | 164 |
2394179 | 2394179 | 2022-04-10 | Williams | North Dakota | 38105 | 10470 | 68 |
2394270 | 2394270 | 2022-04-10 | Williams | Ohio | 39171 | 8999 | 164 |
2390923 | 2390923 | 2022-04-09 | Williams | North Dakota | 38105 | 10470 | 68 |
2391014 | 2391014 | 2022-04-09 | Williams | Ohio | 39171 | 8999 | 164 |
2387667 | 2387667 | 2022-04-08 | Williams | North Dakota | 38105 | 10470 | 68 |
2387758 | 2387758 | 2022-04-08 | Williams | Ohio | 39171 | 8999 | 164 |
2384412 | 2384412 | 2022-04-07 | Williams | North Dakota | 38105 | 10466 | 68 |
2384503 | 2384503 | 2022-04-07 | Williams | Ohio | 39171 | 8999 | 164 |
2381157 | 2381157 | 2022-04-06 | Williams | North Dakota | 38105 | 10466 | 68 |
2381248 | 2381248 | 2022-04-06 | Williams | Ohio | 39171 | 8996 | 164 |
2377902 | 2377902 | 2022-04-05 | Williams | North Dakota | 38105 | 10466 | 68 |
2377993 | 2377993 | 2022-04-05 | Williams | Ohio | 39171 | 8996 | 164 |
2374649 | 2374649 | 2022-04-04 | Williams | North Dakota | 38105 | 10466 | 68 |
2374739 | 2374739 | 2022-04-04 | Williams | Ohio | 39171 | 8996 | 164 |
2371397 | 2371397 | 2022-04-03 | Williams | North Dakota | 38105 | 10466 | 68 |
2371487 | 2371487 | 2022-04-03 | Williams | Ohio | 39171 | 8996 | 164 |
2368144 | 2368144 | 2022-04-02 | Williams | North Dakota | 38105 | 10466 | 68 |
2368234 | 2368234 | 2022-04-02 | Williams | Ohio | 39171 | 8996 | 164 |
2364891 | 2364891 | 2022-04-01 | Williams | North Dakota | 38105 | 10466 | 68 |
2364981 | 2364981 | 2022-04-01 | Williams | Ohio | 39171 | 8996 | 164 |
2361637 | 2361637 | 2022-03-31 | Williams | North Dakota | 38105 | 10464 | 68 |
2361728 | 2361728 | 2022-03-31 | Williams | Ohio | 39171 | 8996 | 164 |
2358383 | 2358383 | 2022-03-30 | Williams | North Dakota | 38105 | 10464 | 68 |
2358474 | 2358474 | 2022-03-30 | Williams | Ohio | 39171 | 8992 | 161 |
2355129 | 2355129 | 2022-03-29 | Williams | North Dakota | 38105 | 10464 | 68 |
2355220 | 2355220 | 2022-03-29 | Williams | Ohio | 39171 | 8992 | 161 |
2351876 | 2351876 | 2022-03-28 | Williams | North Dakota | 38105 | 10464 | 68 |
2351967 | 2351967 | 2022-03-28 | Williams | Ohio | 39171 | 8992 | 161 |
2348624 | 2348624 | 2022-03-27 | Williams | North Dakota | 38105 | 10464 | 68 |
2348715 | 2348715 | 2022-03-27 | Williams | Ohio | 39171 | 8992 | 161 |
2345371 | 2345371 | 2022-03-26 | Williams | North Dakota | 38105 | 10464 | 68 |
2345462 | 2345462 | 2022-03-26 | Williams | Ohio | 39171 | 8992 | 161 |
2342118 | 2342118 | 2022-03-25 | Williams | North Dakota | 38105 | 10464 | 68 |
2342209 | 2342209 | 2022-03-25 | Williams | Ohio | 39171 | 8992 | 161 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);