ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
203 rows where cases = 3634 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 37
- Texas 17
- Wyoming 16
- Virginia 11
- Georgia 10
- Illinois 8
- Kentucky 8
- Indiana 7
- Arkansas 6
- Ohio 6
- Puerto Rico 6
- Tennessee 6
- Alabama 5
- Idaho 5
- Mississippi 5
- Washington 5
- Minnesota 4
- New Mexico 4
- North Carolina 4
- Pennsylvania 4
- California 3
- Kansas 3
- Louisiana 3
- Maine 3
- West Virginia 3
- Iowa 2
- Michigan 2
- Nebraska 2
- New York 2
- Alaska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496598 | 2496598 | 2022-05-12 | Las Animas | Colorado | 8071 | 3634 | 43 |
2492442 | 2492442 | 2022-05-10 | Bandera | Texas | 48019 | 3634 | 77 |
2470887 | 2470887 | 2022-05-04 | Greene | Illinois | 17061 | 3634 | 58 |
2471817 | 2471817 | 2022-05-04 | Macon | Missouri | 29121 | 3634 | 53 |
2468561 | 2468561 | 2022-05-03 | Macon | Missouri | 29121 | 3634 | 53 |
2469382 | 2469382 | 2022-05-03 | Loiza | Puerto Rico | 72087 | 3634 | |
2465305 | 2465305 | 2022-05-02 | Macon | Missouri | 29121 | 3634 | 53 |
2462050 | 2462050 | 2022-05-01 | Macon | Missouri | 29121 | 3634 | 53 |
2458794 | 2458794 | 2022-04-30 | Macon | Missouri | 29121 | 3634 | 53 |
2455538 | 2455538 | 2022-04-29 | Macon | Missouri | 29121 | 3634 | 53 |
2452282 | 2452282 | 2022-04-28 | Macon | Missouri | 29121 | 3634 | 53 |
2449026 | 2449026 | 2022-04-27 | Macon | Missouri | 29121 | 3634 | 53 |
2445769 | 2445769 | 2022-04-26 | Macon | Missouri | 29121 | 3634 | 53 |
2442514 | 2442514 | 2022-04-25 | Macon | Missouri | 29121 | 3634 | 53 |
2444192 | 2444192 | 2022-04-25 | Goshen | Wyoming | 56015 | 3634 | 57 |
2439258 | 2439258 | 2022-04-24 | Macon | Missouri | 29121 | 3634 | 53 |
2440787 | 2440787 | 2022-04-24 | Pacific | Washington | 53049 | 3634 | 57 |
2440936 | 2440936 | 2022-04-24 | Goshen | Wyoming | 56015 | 3634 | 57 |
2436002 | 2436002 | 2022-04-23 | Macon | Missouri | 29121 | 3634 | 53 |
2437531 | 2437531 | 2022-04-23 | Pacific | Washington | 53049 | 3634 | 57 |
2437680 | 2437680 | 2022-04-23 | Goshen | Wyoming | 56015 | 3634 | 57 |
2432746 | 2432746 | 2022-04-22 | Macon | Missouri | 29121 | 3634 | 53 |
2434275 | 2434275 | 2022-04-22 | Pacific | Washington | 53049 | 3634 | 57 |
2434424 | 2434424 | 2022-04-22 | Goshen | Wyoming | 56015 | 3634 | 57 |
2429490 | 2429490 | 2022-04-21 | Macon | Missouri | 29121 | 3634 | 53 |
2431168 | 2431168 | 2022-04-21 | Goshen | Wyoming | 56015 | 3634 | 57 |
2426234 | 2426234 | 2022-04-20 | Macon | Missouri | 29121 | 3634 | 53 |
2427912 | 2427912 | 2022-04-20 | Goshen | Wyoming | 56015 | 3634 | 57 |
2422978 | 2422978 | 2022-04-19 | Macon | Missouri | 29121 | 3634 | 53 |
2424656 | 2424656 | 2022-04-19 | Goshen | Wyoming | 56015 | 3634 | 57 |
2419721 | 2419721 | 2022-04-18 | Macon | Missouri | 29121 | 3634 | 53 |
2421186 | 2421186 | 2022-04-18 | Patrick | Virginia | 51141 | 3634 | 94 |
2416466 | 2416466 | 2022-04-17 | Macon | Missouri | 29121 | 3634 | 53 |
2413210 | 2413210 | 2022-04-16 | Macon | Missouri | 29121 | 3634 | 53 |
2409954 | 2409954 | 2022-04-15 | Macon | Missouri | 29121 | 3634 | 53 |
2406698 | 2406698 | 2022-04-14 | Macon | Missouri | 29121 | 3634 | 53 |
2403442 | 2403442 | 2022-04-13 | Macon | Missouri | 29121 | 3634 | 53 |
2400187 | 2400187 | 2022-04-12 | Macon | Missouri | 29121 | 3634 | 53 |
2396932 | 2396932 | 2022-04-11 | Macon | Missouri | 29121 | 3634 | 53 |
2398610 | 2398610 | 2022-04-11 | Goshen | Wyoming | 56015 | 3634 | 57 |
2393677 | 2393677 | 2022-04-10 | Macon | Missouri | 29121 | 3634 | 53 |
2395355 | 2395355 | 2022-04-10 | Goshen | Wyoming | 56015 | 3634 | 57 |
2390421 | 2390421 | 2022-04-09 | Macon | Missouri | 29121 | 3634 | 53 |
2392099 | 2392099 | 2022-04-09 | Goshen | Wyoming | 56015 | 3634 | 57 |
2387165 | 2387165 | 2022-04-08 | Macon | Missouri | 29121 | 3634 | 53 |
2388843 | 2388843 | 2022-04-08 | Goshen | Wyoming | 56015 | 3634 | 57 |
2383910 | 2383910 | 2022-04-07 | Macon | Missouri | 29121 | 3634 | 53 |
2385588 | 2385588 | 2022-04-07 | Goshen | Wyoming | 56015 | 3634 | 57 |
2380655 | 2380655 | 2022-04-06 | Macon | Missouri | 29121 | 3634 | 53 |
2382333 | 2382333 | 2022-04-06 | Goshen | Wyoming | 56015 | 3634 | 57 |
2377400 | 2377400 | 2022-04-05 | Macon | Missouri | 29121 | 3634 | 53 |
2379078 | 2379078 | 2022-04-05 | Goshen | Wyoming | 56015 | 3634 | 57 |
2374147 | 2374147 | 2022-04-04 | Macon | Missouri | 29121 | 3634 | 53 |
2370895 | 2370895 | 2022-04-03 | Macon | Missouri | 29121 | 3634 | 53 |
2367642 | 2367642 | 2022-04-02 | Macon | Missouri | 29121 | 3634 | 53 |
2364389 | 2364389 | 2022-04-01 | Macon | Missouri | 29121 | 3634 | 53 |
2361135 | 2361135 | 2022-03-31 | Macon | Missouri | 29121 | 3634 | 53 |
2334130 | 2334130 | 2022-03-23 | Gem | Idaho | 16045 | 3634 | 79 |
2306648 | 2306648 | 2022-03-14 | Lares | Puerto Rico | 72081 | 3634 | |
2266282 | 2266282 | 2022-03-02 | Fleming | Kentucky | 21069 | 3634 | 48 |
2268126 | 2268126 | 2022-03-02 | Zapata | Texas | 48505 | 3634 | 52 |
2238658 | 2238658 | 2022-02-21 | Colorado | Texas | 48089 | 3634 | 59 |
2211002 | 2211002 | 2022-02-13 | Casey | Kentucky | 21045 | 3634 | 65 |
2207749 | 2207749 | 2022-02-12 | Casey | Kentucky | 21045 | 3634 | 65 |
2204496 | 2204496 | 2022-02-11 | Casey | Kentucky | 21045 | 3634 | 65 |
2206253 | 2206253 | 2022-02-11 | Madison | Texas | 48313 | 3634 | 50 |
2185455 | 2185455 | 2022-02-05 | Bates | Missouri | 29013 | 3634 | 73 |
2128621 | 2128621 | 2022-01-18 | Carbon | Wyoming | 56007 | 3634 | 50 |
2083243 | 2083243 | 2022-01-05 | Conway | Arkansas | 5029 | 3634 | 49 |
2077105 | 2077105 | 2022-01-03 | Mitchell | Georgia | 13205 | 3634 | 102 |
2073487 | 2073487 | 2022-01-02 | Columbia | Arkansas | 5027 | 3634 | 77 |
2073854 | 2073854 | 2022-01-02 | Mitchell | Georgia | 13205 | 3634 | 102 |
2070603 | 2070603 | 2022-01-01 | Mitchell | Georgia | 13205 | 3634 | 102 |
2067352 | 2067352 | 2021-12-31 | Mitchell | Georgia | 13205 | 3634 | 102 |
2058333 | 2058333 | 2021-12-28 | Somerset | Maryland | 24039 | 3634 | 56 |
2059824 | 2059824 | 2021-12-28 | Gonzales | Texas | 48177 | 3634 | 88 |
2056965 | 2056965 | 2021-12-27 | Brooke | West Virginia | 54009 | 3634 | 86 |
2051086 | 2051086 | 2021-12-26 | Jones | Georgia | 13169 | 3634 | 99 |
2052959 | 2052959 | 2021-12-26 | Canovanas | Puerto Rico | 72029 | 3634 | |
2047836 | 2047836 | 2021-12-25 | Jones | Georgia | 13169 | 3634 | 99 |
2044586 | 2044586 | 2021-12-24 | Jones | Georgia | 13169 | 3634 | 99 |
2020409 | 2020409 | 2021-12-16 | Juniata | Pennsylvania | 42067 | 3634 | 139 |
2009009 | 2009009 | 2021-12-13 | Lawrence | Illinois | 17101 | 3634 | 46 |
1968986 | 1968986 | 2021-11-30 | Carbon | Utah | 49007 | 3634 | 37 |
1939884 | 1939884 | 2021-11-21 | Salem city | Virginia | 51775 | 3634 | 64 |
1936634 | 1936634 | 2021-11-20 | Salem city | Virginia | 51775 | 3634 | 64 |
1933384 | 1933384 | 2021-11-19 | Salem city | Virginia | 51775 | 3634 | 64 |
1898618 | 1898618 | 2021-11-09 | Randolph | Indiana | 18135 | 3634 | 105 |
1896279 | 1896279 | 2021-11-08 | Cass | Nebraska | 31025 | 3634 | 21 |
1873948 | 1873948 | 2021-11-01 | Hocking | Ohio | 39073 | 3634 | 84 |
1870087 | 1870087 | 2021-10-31 | Tishomingo | Mississippi | 28141 | 3634 | 92 |
1866838 | 1866838 | 2021-10-30 | Tishomingo | Mississippi | 28141 | 3634 | 92 |
1866877 | 1866877 | 2021-10-30 | Crawford | Missouri | 29055 | 3634 | 57 |
1863589 | 1863589 | 2021-10-29 | Tishomingo | Mississippi | 28141 | 3634 | 92 |
1851070 | 1851070 | 2021-10-25 | Martin | North Carolina | 37117 | 3634 | 71 |
1842128 | 1842128 | 2021-10-22 | Limestone | Texas | 48293 | 3634 | 107 |
1838879 | 1838879 | 2021-10-21 | Limestone | Texas | 48293 | 3634 | 107 |
1830735 | 1830735 | 2021-10-19 | Assumption | Louisiana | 22007 | 3634 | 57 |
1794443 | 1794443 | 2021-10-08 | Cassia | Idaho | 16031 | 3634 | 34 |
1785561 | 1785561 | 2021-10-05 | Grenada | Mississippi | 28043 | 3634 | 108 |
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);