ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
308 rows where deaths = 490 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Texas 39
- Wisconsin 25
- California 24
- Georgia 23
- Pennsylvania 20
- Ohio 15
- Florida 14
- Louisiana 14
- New York 14
- Indiana 13
- Arizona 12
- New Jersey 10
- Idaho 9
- Illinois 9
- Alabama 7
- Arkansas 7
- North Carolina 7
- Oregon 7
- South Carolina 7
- Missouri 6
- Connecticut 4
- Maryland 4
- Massachusetts 4
- Virginia 4
- Colorado 3
- Minnesota 2
- New Mexico 2
- Washington 2
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499810 | 2499810 | 2022-05-13 | Sonoma | California | 6097 | 90191 | 490 |
2501575 | 2501575 | 2022-05-13 | Union | North Carolina | 37179 | 62697 | 490 |
2496552 | 2496552 | 2022-05-12 | Sonoma | California | 6097 | 89730 | 490 |
2498317 | 2498317 | 2022-05-12 | Union | North Carolina | 37179 | 62697 | 490 |
2493294 | 2493294 | 2022-05-11 | Sonoma | California | 6097 | 89730 | 490 |
2495059 | 2495059 | 2022-05-11 | Union | North Carolina | 37179 | 62697 | 490 |
2490036 | 2490036 | 2022-05-10 | Sonoma | California | 6097 | 89730 | 490 |
2493000 | 2493000 | 2022-05-10 | Marathon | Wisconsin | 55073 | 40111 | 490 |
2486779 | 2486779 | 2022-05-09 | Sonoma | California | 6097 | 89082 | 490 |
2489742 | 2489742 | 2022-05-09 | Marathon | Wisconsin | 55073 | 40057 | 490 |
2483521 | 2483521 | 2022-05-08 | Sonoma | California | 6097 | 89082 | 490 |
2486485 | 2486485 | 2022-05-08 | Marathon | Wisconsin | 55073 | 39928 | 490 |
2480263 | 2480263 | 2022-05-07 | Sonoma | California | 6097 | 89082 | 490 |
2483227 | 2483227 | 2022-05-07 | Marathon | Wisconsin | 55073 | 39928 | 490 |
2477005 | 2477005 | 2022-05-06 | Sonoma | California | 6097 | 89082 | 490 |
2479969 | 2479969 | 2022-05-06 | Marathon | Wisconsin | 55073 | 39928 | 490 |
2473747 | 2473747 | 2022-05-05 | Sonoma | California | 6097 | 88499 | 490 |
2476711 | 2476711 | 2022-05-05 | Marathon | Wisconsin | 55073 | 39850 | 490 |
2470490 | 2470490 | 2022-05-04 | Sonoma | California | 6097 | 88499 | 490 |
2473453 | 2473453 | 2022-05-04 | Marathon | Wisconsin | 55073 | 39799 | 490 |
2467234 | 2467234 | 2022-05-03 | Sonoma | California | 6097 | 88499 | 490 |
2470196 | 2470196 | 2022-05-03 | Marathon | Wisconsin | 55073 | 39719 | 490 |
2463979 | 2463979 | 2022-05-02 | Sonoma | California | 6097 | 88095 | 490 |
2466940 | 2466940 | 2022-05-02 | Marathon | Wisconsin | 55073 | 39697 | 490 |
2460723 | 2460723 | 2022-05-01 | Sonoma | California | 6097 | 88095 | 490 |
2463685 | 2463685 | 2022-05-01 | Marathon | Wisconsin | 55073 | 39582 | 490 |
2457467 | 2457467 | 2022-04-30 | Sonoma | California | 6097 | 88095 | 490 |
2460429 | 2460429 | 2022-04-30 | Marathon | Wisconsin | 55073 | 39582 | 490 |
2454211 | 2454211 | 2022-04-29 | Sonoma | California | 6097 | 88095 | 490 |
2457173 | 2457173 | 2022-04-29 | Marathon | Wisconsin | 55073 | 39582 | 490 |
2450955 | 2450955 | 2022-04-28 | Sonoma | California | 6097 | 87684 | 490 |
2453917 | 2453917 | 2022-04-28 | Marathon | Wisconsin | 55073 | 39561 | 490 |
2447699 | 2447699 | 2022-04-27 | Sonoma | California | 6097 | 87684 | 490 |
2450661 | 2450661 | 2022-04-27 | Marathon | Wisconsin | 55073 | 39499 | 490 |
2447405 | 2447405 | 2022-04-26 | Marathon | Wisconsin | 55073 | 39468 | 490 |
2444149 | 2444149 | 2022-04-25 | Marathon | Wisconsin | 55073 | 39459 | 490 |
2417862 | 2417862 | 2022-04-17 | Chesapeake city | Virginia | 51550 | 50060 | 490 |
2414606 | 2414606 | 2022-04-16 | Chesapeake city | Virginia | 51550 | 50060 | 490 |
2411350 | 2411350 | 2022-04-15 | Chesapeake city | Virginia | 51550 | 50060 | 490 |
2379560 | 2379560 | 2022-04-06 | Houston | Georgia | 13153 | 39322 | 490 |
2376306 | 2376306 | 2022-04-05 | Houston | Georgia | 13153 | 39322 | 490 |
2373054 | 2373054 | 2022-04-04 | Houston | Georgia | 13153 | 39313 | 490 |
2373717 | 2373717 | 2022-04-04 | Bossier | Louisiana | 22015 | 37474 | 490 |
2370464 | 2370464 | 2022-04-03 | Bossier | Louisiana | 22015 | 37472 | 490 |
2367211 | 2367211 | 2022-04-02 | Bossier | Louisiana | 22015 | 37472 | 490 |
2363958 | 2363958 | 2022-04-01 | Bossier | Louisiana | 22015 | 37472 | 490 |
2360704 | 2360704 | 2022-03-31 | Bossier | Louisiana | 22015 | 37470 | 490 |
2359141 | 2359141 | 2022-03-30 | Randall | Texas | 48381 | 38116 | 490 |
2329295 | 2329295 | 2022-03-21 | Lane | Oregon | 41039 | 56928 | 490 |
2324941 | 2324941 | 2022-03-20 | Lafayette | Louisiana | 22055 | 62197 | 490 |
2326043 | 2326043 | 2022-03-20 | Lane | Oregon | 41039 | 56882 | 490 |
2321687 | 2321687 | 2022-03-19 | Lafayette | Louisiana | 22055 | 62197 | 490 |
2322790 | 2322790 | 2022-03-19 | Lane | Oregon | 41039 | 56882 | 490 |
2318433 | 2318433 | 2022-03-18 | Lafayette | Louisiana | 22055 | 62197 | 490 |
2319536 | 2319536 | 2022-03-18 | Lane | Oregon | 41039 | 56882 | 490 |
2304190 | 2304190 | 2022-03-13 | Dane | Wisconsin | 55025 | 122823 | 490 |
2297905 | 2297905 | 2022-03-12 | Garland | Arkansas | 5051 | 22947 | 490 |
2300938 | 2300938 | 2022-03-12 | Dane | Wisconsin | 55025 | 122823 | 490 |
2297686 | 2297686 | 2022-03-11 | Dane | Wisconsin | 55025 | 122823 | 490 |
2288064 | 2288064 | 2022-03-09 | Morgan | Alabama | 1103 | 35902 | 490 |
2290323 | 2290323 | 2022-03-09 | Mercer | Pennsylvania | 42085 | 23212 | 490 |
2287071 | 2287071 | 2022-03-08 | Mercer | Pennsylvania | 42085 | 23208 | 490 |
2283819 | 2283819 | 2022-03-07 | Mercer | Pennsylvania | 42085 | 23202 | 490 |
2284670 | 2284670 | 2022-03-07 | Brown | Wisconsin | 55009 | 83557 | 490 |
2280567 | 2280567 | 2022-03-06 | Mercer | Pennsylvania | 42085 | 23201 | 490 |
2281418 | 2281418 | 2022-03-06 | Brown | Wisconsin | 55009 | 83520 | 490 |
2278165 | 2278165 | 2022-03-05 | Brown | Wisconsin | 55009 | 83520 | 490 |
2274912 | 2274912 | 2022-03-04 | Brown | Wisconsin | 55009 | 83520 | 490 |
2270591 | 2270591 | 2022-03-03 | Greene | Ohio | 39057 | 37224 | 490 |
2270614 | 2270614 | 2022-03-03 | Medina | Ohio | 39103 | 39812 | 490 |
2271659 | 2271659 | 2022-03-03 | Brown | Wisconsin | 55009 | 83498 | 490 |
2267339 | 2267339 | 2022-03-02 | Greene | Ohio | 39057 | 37174 | 490 |
2267362 | 2267362 | 2022-03-02 | Medina | Ohio | 39103 | 39793 | 490 |
2262170 | 2262170 | 2022-03-01 | Sebastian | Arkansas | 5131 | 32399 | 490 |
2264086 | 2264086 | 2022-03-01 | Greene | Ohio | 39057 | 37145 | 490 |
2264109 | 2264109 | 2022-03-01 | Medina | Ohio | 39103 | 39780 | 490 |
2255940 | 2255940 | 2022-02-27 | Floyd | Georgia | 13115 | 26941 | 490 |
2252689 | 2252689 | 2022-02-26 | Floyd | Georgia | 13115 | 26941 | 490 |
2249438 | 2249438 | 2022-02-25 | Floyd | Georgia | 13115 | 26941 | 490 |
2225287 | 2225287 | 2022-02-17 | Lebanon | Pennsylvania | 42075 | 36128 | 490 |
2221996 | 2221996 | 2022-02-16 | Washington | Oregon | 41067 | 82681 | 490 |
2202527 | 2202527 | 2022-02-10 | Lycoming | Pennsylvania | 42081 | 27736 | 490 |
2202975 | 2202975 | 2022-02-10 | Kaufman | Texas | 48257 | 34274 | 490 |
2198179 | 2198179 | 2022-02-09 | Frederick | Maryland | 24021 | 43369 | 490 |
2198814 | 2198814 | 2022-02-09 | Albany | New York | 36001 | 56961 | 490 |
2194925 | 2194925 | 2022-02-08 | Frederick | Maryland | 24021 | 43327 | 490 |
2195560 | 2195560 | 2022-02-08 | Albany | New York | 36001 | 56818 | 490 |
2192306 | 2192306 | 2022-02-07 | Albany | New York | 36001 | 56760 | 490 |
2192691 | 2192691 | 2022-02-07 | Clackamas | Oregon | 41005 | 56665 | 490 |
2178130 | 2178130 | 2022-02-03 | Rock Island | Illinois | 17161 | 31762 | 490 |
2174877 | 2174877 | 2022-02-02 | Rock Island | Illinois | 17161 | 31762 | 490 |
2166285 | 2166285 | 2022-01-30 | Broome | New York | 36007 | 42294 | 490 |
2163030 | 2163030 | 2022-01-29 | Broome | New York | 36007 | 42136 | 490 |
2159775 | 2159775 | 2022-01-28 | Broome | New York | 36007 | 41979 | 490 |
2156586 | 2156586 | 2022-01-27 | Buncombe | North Carolina | 37021 | 44348 | 490 |
2145197 | 2145197 | 2022-01-24 | Mesa | Colorado | 8077 | 36623 | 490 |
2143582 | 2143582 | 2022-01-23 | Catawba | North Carolina | 37035 | 39619 | 490 |
2140327 | 2140327 | 2022-01-22 | Catawba | North Carolina | 37035 | 39619 | 490 |
2141022 | 2141022 | 2022-01-22 | Unknown | Tennessee | 86065 | 490 | |
2137071 | 2137071 | 2022-01-21 | Catawba | North Carolina | 37035 | 39619 | 490 |
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);