ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,526 rows where cases = 17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 434
- Kentucky 240
- Colorado 202
- Georgia 195
- Missouri 186
- Nebraska 172
- Illinois 167
- Kansas 166
- Michigan 165
- Virginia 158
- Iowa 150
- Tennessee 145
- Minnesota 135
- South Dakota 128
- Montana 119
- West Virginia 111
- Arkansas 104
- Indiana 100
- Wisconsin 99
- Puerto Rico 97
- North Carolina 91
- Ohio 91
- Oklahoma 88
- Mississippi 77
- Idaho 72
- North Dakota 71
- Pennsylvania 71
- Oregon 61
- New Mexico 57
- Maine 50
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2422618 | 2422618 | 2022-04-19 | Unknown | Maine | 17 | 0 | |
2419362 | 2419362 | 2022-04-18 | Unknown | Maine | 17 | 0 | |
2416106 | 2416106 | 2022-04-17 | Unknown | Maine | 17 | 0 | |
2412850 | 2412850 | 2022-04-16 | Unknown | Maine | 17 | 0 | |
2403731 | 2403731 | 2022-04-13 | Unknown | New Mexico | 17 | 0 | |
2284870 | 2284870 | 2022-03-08 | Unknown | Arizona | 17 | 0 | |
2281618 | 2281618 | 2022-03-07 | Unknown | Arizona | 17 | 0 | |
2278365 | 2278365 | 2022-03-06 | Unknown | Arizona | 17 | 0 | |
2275112 | 2275112 | 2022-03-05 | Unknown | Arizona | 17 | 0 | |
2271859 | 2271859 | 2022-03-04 | Unknown | Arizona | 17 | 0 | |
2268607 | 2268607 | 2022-03-03 | Unknown | Arizona | 17 | 0 | |
2265354 | 2265354 | 2022-03-02 | Unknown | Arizona | 17 | 0 | |
2211825 | 2211825 | 2022-02-13 | Unknown | New Mexico | 17 | 0 | |
2208572 | 2208572 | 2022-02-12 | Unknown | New Mexico | 17 | 0 | |
2205319 | 2205319 | 2022-02-11 | Unknown | New Mexico | 17 | 0 | |
2143505 | 2143505 | 2022-01-23 | Unknown | New Mexico | 17 | 0 | |
2140250 | 2140250 | 2022-01-22 | Unknown | New Mexico | 17 | 0 | |
2136994 | 2136994 | 2022-01-21 | Unknown | New Mexico | 17 | 0 | |
2006306 | 2006306 | 2021-12-12 | Unknown | Maine | 17 | 0 | |
1828010 | 1828010 | 2021-10-18 | Petroleum | Montana | 30069 | 17 | 1 |
1824761 | 1824761 | 2021-10-17 | Petroleum | Montana | 30069 | 17 | 1 |
1821512 | 1821512 | 2021-10-16 | Petroleum | Montana | 30069 | 17 | 1 |
1818263 | 1818263 | 2021-10-15 | Petroleum | Montana | 30069 | 17 | 1 |
1815014 | 1815014 | 2021-10-14 | Petroleum | Montana | 30069 | 17 | 1 |
1811766 | 1811766 | 2021-10-13 | Petroleum | Montana | 30069 | 17 | 1 |
1794755 | 1794755 | 2021-10-08 | Unknown | Iowa | 17 | 0 | |
1791507 | 1791507 | 2021-10-07 | Unknown | Iowa | 17 | 0 | |
1788258 | 1788258 | 2021-10-06 | Unknown | Iowa | 17 | 0 | |
1294047 | 1294047 | 2021-05-07 | Hinsdale | Colorado | 8053 | 17 | 0 |
1290801 | 1290801 | 2021-05-06 | Hinsdale | Colorado | 8053 | 17 | 0 |
1293447 | 1293447 | 2021-05-06 | Unknown | Vermont | 17 | 0 | |
1284309 | 1284309 | 2021-05-04 | Hinsdale | Colorado | 8053 | 17 | 0 |
1281062 | 1281062 | 2021-05-03 | Hinsdale | Colorado | 8053 | 17 | 0 |
1277815 | 1277815 | 2021-05-02 | Hinsdale | Colorado | 8053 | 17 | 0 |
1271321 | 1271321 | 2021-04-30 | Hinsdale | Colorado | 8053 | 17 | 0 |
1248592 | 1248592 | 2021-04-23 | Hinsdale | Colorado | 8053 | 17 | 0 |
1245345 | 1245345 | 2021-04-22 | Hinsdale | Colorado | 8053 | 17 | 0 |
1242098 | 1242098 | 2021-04-21 | Hinsdale | Colorado | 8053 | 17 | 0 |
1238851 | 1238851 | 2021-04-20 | Hinsdale | Colorado | 8053 | 17 | 0 |
1235604 | 1235604 | 2021-04-19 | Hinsdale | Colorado | 8053 | 17 | 0 |
1229108 | 1229108 | 2021-04-17 | Hinsdale | Colorado | 8053 | 17 | 0 |
1225860 | 1225860 | 2021-04-16 | Hinsdale | Colorado | 8053 | 17 | 0 |
1222613 | 1222613 | 2021-04-15 | Hinsdale | Colorado | 8053 | 17 | 0 |
1216117 | 1216117 | 2021-04-13 | Hinsdale | Colorado | 8053 | 17 | 0 |
1209622 | 1209622 | 2021-04-11 | Hinsdale | Colorado | 8053 | 17 | 0 |
1206373 | 1206373 | 2021-04-10 | Hinsdale | Colorado | 8053 | 17 | 0 |
1203125 | 1203125 | 2021-04-09 | Hinsdale | Colorado | 8053 | 17 | 0 |
1196628 | 1196628 | 2021-04-07 | Hinsdale | Colorado | 8053 | 17 | 0 |
1193380 | 1193380 | 2021-04-06 | Hinsdale | Colorado | 8053 | 17 | 0 |
1186883 | 1186883 | 2021-04-04 | Hinsdale | Colorado | 8053 | 17 | 0 |
1173895 | 1173895 | 2021-03-31 | Hinsdale | Colorado | 8053 | 17 | 0 |
1167400 | 1167400 | 2021-03-29 | Hinsdale | Colorado | 8053 | 17 | 0 |
1160904 | 1160904 | 2021-03-27 | Hinsdale | Colorado | 8053 | 17 | 0 |
1157656 | 1157656 | 2021-03-26 | Hinsdale | Colorado | 8053 | 17 | 0 |
1154409 | 1154409 | 2021-03-25 | Hinsdale | Colorado | 8053 | 17 | 0 |
1151162 | 1151162 | 2021-03-24 | Hinsdale | Colorado | 8053 | 17 | 0 |
1147915 | 1147915 | 2021-03-23 | Hinsdale | Colorado | 8053 | 17 | 0 |
1141421 | 1141421 | 2021-03-21 | Hinsdale | Colorado | 8053 | 17 | 0 |
1138175 | 1138175 | 2021-03-20 | Hinsdale | Colorado | 8053 | 17 | 0 |
1134929 | 1134929 | 2021-03-19 | Hinsdale | Colorado | 8053 | 17 | 0 |
1118695 | 1118695 | 2021-03-14 | Hinsdale | Colorado | 8053 | 17 | 0 |
1115448 | 1115448 | 2021-03-13 | Hinsdale | Colorado | 8053 | 17 | 0 |
1112202 | 1112202 | 2021-03-12 | Hinsdale | Colorado | 8053 | 17 | 0 |
1114151 | 1114151 | 2021-03-12 | Unknown | Oklahoma | 17 | 0 | |
1099218 | 1099218 | 2021-03-08 | Hinsdale | Colorado | 8053 | 17 | 0 |
1082987 | 1082987 | 2021-03-03 | Hinsdale | Colorado | 8053 | 17 | 0 |
1076496 | 1076496 | 2021-03-01 | Hinsdale | Colorado | 8053 | 17 | 0 |
1073250 | 1073250 | 2021-02-28 | Hinsdale | Colorado | 8053 | 17 | 0 |
1070004 | 1070004 | 2021-02-27 | Hinsdale | Colorado | 8053 | 17 | 0 |
1066759 | 1066759 | 2021-02-26 | Hinsdale | Colorado | 8053 | 17 | 0 |
1063514 | 1063514 | 2021-02-25 | Hinsdale | Colorado | 8053 | 17 | 0 |
1060269 | 1060269 | 2021-02-24 | Hinsdale | Colorado | 8053 | 17 | 0 |
1047283 | 1047283 | 2021-02-20 | Hinsdale | Colorado | 8053 | 17 | 0 |
1044038 | 1044038 | 2021-02-19 | Hinsdale | Colorado | 8053 | 17 | 0 |
1040793 | 1040793 | 2021-02-18 | Hinsdale | Colorado | 8053 | 17 | 0 |
1031057 | 1031057 | 2021-02-15 | Hinsdale | Colorado | 8053 | 17 | 0 |
1014830 | 1014830 | 2021-02-10 | Hinsdale | Colorado | 8053 | 17 | 0 |
1010706 | 1010706 | 2021-02-08 | Borden | Texas | 48033 | 17 | 2 |
1007460 | 1007460 | 2021-02-07 | Borden | Texas | 48033 | 17 | 2 |
1004214 | 1004214 | 2021-02-06 | Borden | Texas | 48033 | 17 | 2 |
1000968 | 1000968 | 2021-02-05 | Borden | Texas | 48033 | 17 | 2 |
997722 | 997722 | 2021-02-04 | Borden | Texas | 48033 | 17 | 2 |
994476 | 994476 | 2021-02-03 | Borden | Texas | 48033 | 17 | 1 |
991230 | 991230 | 2021-02-02 | Borden | Texas | 48033 | 17 | 0 |
987984 | 987984 | 2021-02-01 | Borden | Texas | 48033 | 17 | 0 |
984737 | 984737 | 2021-01-31 | Borden | Texas | 48033 | 17 | 0 |
981490 | 981490 | 2021-01-30 | Borden | Texas | 48033 | 17 | 0 |
978244 | 978244 | 2021-01-29 | Borden | Texas | 48033 | 17 | 0 |
974999 | 974999 | 2021-01-28 | Borden | Texas | 48033 | 17 | 0 |
925943 | 925943 | 2021-01-13 | Wheeler | Oregon | 41069 | 17 | 1 |
922697 | 922697 | 2021-01-12 | Wheeler | Oregon | 41069 | 17 | 1 |
918866 | 918866 | 2021-01-11 | Blaine | Nebraska | 31009 | 17 | 0 |
919452 | 919452 | 2021-01-11 | Wheeler | Oregon | 41069 | 17 | 1 |
915621 | 915621 | 2021-01-10 | Blaine | Nebraska | 31009 | 17 | 0 |
916207 | 916207 | 2021-01-10 | Wheeler | Oregon | 41069 | 17 | 1 |
912962 | 912962 | 2021-01-09 | Wheeler | Oregon | 41069 | 17 | 1 |
909131 | 909131 | 2021-01-08 | Blaine | Nebraska | 31009 | 17 | 0 |
909717 | 909717 | 2021-01-08 | Wheeler | Oregon | 41069 | 17 | 1 |
906472 | 906472 | 2021-01-07 | Wheeler | Oregon | 41069 | 17 | 1 |
903226 | 903226 | 2021-01-06 | Wheeler | Oregon | 41069 | 17 | 1 |
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);