ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
507 rows where cases = 977 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 70
- Missouri 47
- Nebraska 34
- Georgia 28
- Kentucky 27
- Iowa 23
- Louisiana 19
- Virginia 18
- North Carolina 17
- Kansas 16
- Minnesota 16
- Mississippi 15
- Alabama 12
- Montana 11
- North Dakota 11
- Oklahoma 11
- Arkansas 10
- Puerto Rico 10
- Idaho 9
- Illinois 9
- Indiana 9
- Michigan 8
- Ohio 8
- West Virginia 8
- Florida 7
- South Carolina 6
- Washington 5
- Alaska 4
- Tennessee 4
- Colorado 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499844 | 2499844 | 2022-05-13 | Gilpin | Colorado | 8047 | 977 | 4 |
2471809 | 2471809 | 2022-05-04 | Knox | Missouri | 29103 | 977 | 13 |
2468553 | 2468553 | 2022-05-03 | Knox | Missouri | 29103 | 977 | 13 |
2465297 | 2465297 | 2022-05-02 | Knox | Missouri | 29103 | 977 | 13 |
2462042 | 2462042 | 2022-05-01 | Knox | Missouri | 29103 | 977 | 13 |
2458786 | 2458786 | 2022-04-30 | Knox | Missouri | 29103 | 977 | 13 |
2455530 | 2455530 | 2022-04-29 | Knox | Missouri | 29103 | 977 | 13 |
2452274 | 2452274 | 2022-04-28 | Knox | Missouri | 29103 | 977 | 13 |
2449018 | 2449018 | 2022-04-27 | Knox | Missouri | 29103 | 977 | 13 |
2445761 | 2445761 | 2022-04-26 | Knox | Missouri | 29103 | 977 | 13 |
2446206 | 2446206 | 2022-04-26 | Tyrrell | North Carolina | 37177 | 977 | 8 |
2442506 | 2442506 | 2022-04-25 | Knox | Missouri | 29103 | 977 | 13 |
2442951 | 2442951 | 2022-04-25 | Tyrrell | North Carolina | 37177 | 977 | 8 |
2439250 | 2439250 | 2022-04-24 | Knox | Missouri | 29103 | 977 | 13 |
2439695 | 2439695 | 2022-04-24 | Tyrrell | North Carolina | 37177 | 977 | 8 |
2440516 | 2440516 | 2022-04-24 | Presidio | Texas | 48377 | 977 | 38 |
2435994 | 2435994 | 2022-04-23 | Knox | Missouri | 29103 | 977 | 13 |
2436439 | 2436439 | 2022-04-23 | Tyrrell | North Carolina | 37177 | 977 | 8 |
2437260 | 2437260 | 2022-04-23 | Presidio | Texas | 48377 | 977 | 38 |
2432738 | 2432738 | 2022-04-22 | Knox | Missouri | 29103 | 977 | 13 |
2433183 | 2433183 | 2022-04-22 | Tyrrell | North Carolina | 37177 | 977 | 8 |
2434004 | 2434004 | 2022-04-22 | Presidio | Texas | 48377 | 977 | 38 |
2429482 | 2429482 | 2022-04-21 | Knox | Missouri | 29103 | 977 | 13 |
2429927 | 2429927 | 2022-04-21 | Tyrrell | North Carolina | 37177 | 977 | 8 |
2430748 | 2430748 | 2022-04-21 | Presidio | Texas | 48377 | 977 | 37 |
2426226 | 2426226 | 2022-04-20 | Knox | Missouri | 29103 | 977 | 13 |
2426671 | 2426671 | 2022-04-20 | Tyrrell | North Carolina | 37177 | 977 | 8 |
2427492 | 2427492 | 2022-04-20 | Presidio | Texas | 48377 | 977 | 37 |
2422970 | 2422970 | 2022-04-19 | Knox | Missouri | 29103 | 977 | 13 |
2424236 | 2424236 | 2022-04-19 | Presidio | Texas | 48377 | 977 | 37 |
2419713 | 2419713 | 2022-04-18 | Knox | Missouri | 29103 | 977 | 13 |
2420980 | 2420980 | 2022-04-18 | Presidio | Texas | 48377 | 977 | 37 |
2416458 | 2416458 | 2022-04-17 | Knox | Missouri | 29103 | 977 | 13 |
2417724 | 2417724 | 2022-04-17 | Presidio | Texas | 48377 | 977 | 37 |
2413202 | 2413202 | 2022-04-16 | Knox | Missouri | 29103 | 977 | 13 |
2414468 | 2414468 | 2022-04-16 | Presidio | Texas | 48377 | 977 | 37 |
2409946 | 2409946 | 2022-04-15 | Knox | Missouri | 29103 | 977 | 13 |
2411212 | 2411212 | 2022-04-15 | Presidio | Texas | 48377 | 977 | 37 |
2406690 | 2406690 | 2022-04-14 | Knox | Missouri | 29103 | 977 | 13 |
2407956 | 2407956 | 2022-04-14 | Presidio | Texas | 48377 | 977 | 37 |
2403434 | 2403434 | 2022-04-13 | Knox | Missouri | 29103 | 977 | 13 |
2404700 | 2404700 | 2022-04-13 | Presidio | Texas | 48377 | 977 | 37 |
2400179 | 2400179 | 2022-04-12 | Knox | Missouri | 29103 | 977 | 13 |
2400363 | 2400363 | 2022-04-12 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2401445 | 2401445 | 2022-04-12 | Presidio | Texas | 48377 | 977 | 37 |
2396924 | 2396924 | 2022-04-11 | Knox | Missouri | 29103 | 977 | 13 |
2397108 | 2397108 | 2022-04-11 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2398190 | 2398190 | 2022-04-11 | Presidio | Texas | 48377 | 977 | 37 |
2393669 | 2393669 | 2022-04-10 | Knox | Missouri | 29103 | 977 | 13 |
2393853 | 2393853 | 2022-04-10 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2394935 | 2394935 | 2022-04-10 | Presidio | Texas | 48377 | 977 | 37 |
2390413 | 2390413 | 2022-04-09 | Knox | Missouri | 29103 | 977 | 13 |
2390597 | 2390597 | 2022-04-09 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2391679 | 2391679 | 2022-04-09 | Presidio | Texas | 48377 | 977 | 37 |
2387157 | 2387157 | 2022-04-08 | Knox | Missouri | 29103 | 977 | 13 |
2387341 | 2387341 | 2022-04-08 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2388423 | 2388423 | 2022-04-08 | Presidio | Texas | 48377 | 977 | 37 |
2383902 | 2383902 | 2022-04-07 | Knox | Missouri | 29103 | 977 | 13 |
2384086 | 2384086 | 2022-04-07 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2385168 | 2385168 | 2022-04-07 | Presidio | Texas | 48377 | 977 | 37 |
2380647 | 2380647 | 2022-04-06 | Knox | Missouri | 29103 | 977 | 13 |
2380831 | 2380831 | 2022-04-06 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2381913 | 2381913 | 2022-04-06 | Presidio | Texas | 48377 | 977 | 37 |
2377392 | 2377392 | 2022-04-05 | Knox | Missouri | 29103 | 977 | 13 |
2377576 | 2377576 | 2022-04-05 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2378658 | 2378658 | 2022-04-05 | Presidio | Texas | 48377 | 977 | 37 |
2374139 | 2374139 | 2022-04-04 | Knox | Missouri | 29103 | 977 | 13 |
2374323 | 2374323 | 2022-04-04 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2375404 | 2375404 | 2022-04-04 | Presidio | Texas | 48377 | 977 | 37 |
2370887 | 2370887 | 2022-04-03 | Knox | Missouri | 29103 | 977 | 13 |
2371071 | 2371071 | 2022-04-03 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2372152 | 2372152 | 2022-04-03 | Presidio | Texas | 48377 | 977 | 37 |
2367634 | 2367634 | 2022-04-02 | Knox | Missouri | 29103 | 977 | 13 |
2367818 | 2367818 | 2022-04-02 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2368899 | 2368899 | 2022-04-02 | Presidio | Texas | 48377 | 977 | 37 |
2364381 | 2364381 | 2022-04-01 | Knox | Missouri | 29103 | 977 | 13 |
2364565 | 2364565 | 2022-04-01 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2365646 | 2365646 | 2022-04-01 | Presidio | Texas | 48377 | 977 | 37 |
2361127 | 2361127 | 2022-03-31 | Knox | Missouri | 29103 | 977 | 13 |
2361311 | 2361311 | 2022-03-31 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2362393 | 2362393 | 2022-03-31 | Presidio | Texas | 48377 | 977 | 37 |
2357873 | 2357873 | 2022-03-30 | Knox | Missouri | 29103 | 977 | 13 |
2358057 | 2358057 | 2022-03-30 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2359139 | 2359139 | 2022-03-30 | Presidio | Texas | 48377 | 977 | 37 |
2354804 | 2354804 | 2022-03-29 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2355885 | 2355885 | 2022-03-29 | Presidio | Texas | 48377 | 977 | 37 |
2351551 | 2351551 | 2022-03-28 | Nuckolls | Nebraska | 31129 | 977 | 13 |
2352632 | 2352632 | 2022-03-28 | Presidio | Texas | 48377 | 977 | 37 |
2349380 | 2349380 | 2022-03-27 | Presidio | Texas | 48377 | 977 | 37 |
2346127 | 2346127 | 2022-03-26 | Presidio | Texas | 48377 | 977 | 37 |
2324812 | 2324812 | 2022-03-20 | Carlisle | Kentucky | 21039 | 977 | 19 |
2321558 | 2321558 | 2022-03-19 | Carlisle | Kentucky | 21039 | 977 | 19 |
2318304 | 2318304 | 2022-03-18 | Carlisle | Kentucky | 21039 | 977 | 19 |
2315051 | 2315051 | 2022-03-17 | Carlisle | Kentucky | 21039 | 977 | 19 |
2311798 | 2311798 | 2022-03-16 | Carlisle | Kentucky | 21039 | 977 | 19 |
2308545 | 2308545 | 2022-03-15 | Carlisle | Kentucky | 21039 | 977 | 19 |
2305294 | 2305294 | 2022-03-14 | Carlisle | Kentucky | 21039 | 977 | 19 |
2277026 | 2277026 | 2022-03-05 | Foster | North Dakota | 38031 | 977 | 23 |
2273773 | 2273773 | 2022-03-04 | Foster | North Dakota | 38031 | 977 | 22 |
2270520 | 2270520 | 2022-03-03 | Foster | North Dakota | 38031 | 977 | 22 |
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);