ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
345 rows where deaths = 456 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 40
- Georgia 30
- California 27
- Michigan 23
- Pennsylvania 22
- Louisiana 19
- North Carolina 18
- Connecticut 17
- Arizona 15
- Washington 15
- Wisconsin 13
- Virginia 10
- South Carolina 9
- Oregon 8
- Alabama 7
- Iowa 7
- New Jersey 6
- Florida 5
- Indiana 5
- New York 5
- Ohio 5
- Tennessee 5
- Utah 5
- Arkansas 4
- Colorado 4
- Illinois 4
- Minnesota 4
- New Mexico 4
- Kansas 3
- Idaho 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490298 | 2490298 | 2022-05-10 | Newton | Georgia | 13217 | 24722 | 456 |
2487041 | 2487041 | 2022-05-09 | Newton | Georgia | 13217 | 24722 | 456 |
2483783 | 2483783 | 2022-05-08 | Newton | Georgia | 13217 | 24722 | 456 |
2480525 | 2480525 | 2022-05-07 | Newton | Georgia | 13217 | 24722 | 456 |
2477267 | 2477267 | 2022-05-06 | Newton | Georgia | 13217 | 24722 | 456 |
2474009 | 2474009 | 2022-05-05 | Newton | Georgia | 13217 | 24722 | 456 |
2470752 | 2470752 | 2022-05-04 | Newton | Georgia | 13217 | 24722 | 456 |
2467496 | 2467496 | 2022-05-03 | Newton | Georgia | 13217 | 24664 | 456 |
2464241 | 2464241 | 2022-05-02 | Newton | Georgia | 13217 | 24664 | 456 |
2460985 | 2460985 | 2022-05-01 | Newton | Georgia | 13217 | 24664 | 456 |
2457729 | 2457729 | 2022-04-30 | Newton | Georgia | 13217 | 24664 | 456 |
2454473 | 2454473 | 2022-04-29 | Newton | Georgia | 13217 | 24664 | 456 |
2451217 | 2451217 | 2022-04-28 | Newton | Georgia | 13217 | 24664 | 456 |
2447961 | 2447961 | 2022-04-27 | Newton | Georgia | 13217 | 24664 | 456 |
2444620 | 2444620 | 2022-04-26 | Carroll | Georgia | 13045 | 23785 | 456 |
2441364 | 2441364 | 2022-04-25 | Carroll | Georgia | 13045 | 23785 | 456 |
2438108 | 2438108 | 2022-04-24 | Carroll | Georgia | 13045 | 23785 | 456 |
2434852 | 2434852 | 2022-04-23 | Carroll | Georgia | 13045 | 23785 | 456 |
2431596 | 2431596 | 2022-04-22 | Carroll | Georgia | 13045 | 23785 | 456 |
2428239 | 2428239 | 2022-04-21 | Litchfield | Connecticut | 9005 | 32254 | 456 |
2428340 | 2428340 | 2022-04-21 | Carroll | Georgia | 13045 | 23785 | 456 |
2424983 | 2424983 | 2022-04-20 | Litchfield | Connecticut | 9005 | 32219 | 456 |
2425084 | 2425084 | 2022-04-20 | Carroll | Georgia | 13045 | 23785 | 456 |
2421727 | 2421727 | 2022-04-19 | Litchfield | Connecticut | 9005 | 32172 | 456 |
2418471 | 2418471 | 2022-04-18 | Litchfield | Connecticut | 9005 | 32105 | 456 |
2415215 | 2415215 | 2022-04-17 | Litchfield | Connecticut | 9005 | 32023 | 456 |
2411959 | 2411959 | 2022-04-16 | Litchfield | Connecticut | 9005 | 32023 | 456 |
2408703 | 2408703 | 2022-04-15 | Litchfield | Connecticut | 9005 | 32023 | 456 |
2405447 | 2405447 | 2022-04-14 | Litchfield | Connecticut | 9005 | 31978 | 456 |
2402192 | 2402192 | 2022-04-13 | Litchfield | Connecticut | 9005 | 31962 | 456 |
2398937 | 2398937 | 2022-04-12 | Litchfield | Connecticut | 9005 | 31929 | 456 |
2400536 | 2400536 | 2022-04-12 | Alamance | North Carolina | 37001 | 46732 | 456 |
2397281 | 2397281 | 2022-04-11 | Alamance | North Carolina | 37001 | 46732 | 456 |
2394026 | 2394026 | 2022-04-10 | Alamance | North Carolina | 37001 | 46732 | 456 |
2390770 | 2390770 | 2022-04-09 | Alamance | North Carolina | 37001 | 46732 | 456 |
2387514 | 2387514 | 2022-04-08 | Alamance | North Carolina | 37001 | 46732 | 456 |
2388226 | 2388226 | 2022-04-08 | Unknown | Tennessee | 18603 | 456 | |
2384259 | 2384259 | 2022-04-07 | Alamance | North Carolina | 37001 | 46732 | 456 |
2384971 | 2384971 | 2022-04-07 | Unknown | Tennessee | 18424 | 456 | |
2381004 | 2381004 | 2022-04-06 | Alamance | North Carolina | 37001 | 46732 | 456 |
2377749 | 2377749 | 2022-04-05 | Alamance | North Carolina | 37001 | 46727 | 456 |
2374496 | 2374496 | 2022-04-04 | Alamance | North Carolina | 37001 | 46731 | 456 |
2336460 | 2336460 | 2022-03-23 | Washington | Utah | 49053 | 44662 | 456 |
2307622 | 2307622 | 2022-03-15 | Coconino | Arizona | 4005 | 43213 | 456 |
2304371 | 2304371 | 2022-03-14 | Coconino | Arizona | 4005 | 43213 | 456 |
2301119 | 2301119 | 2022-03-13 | Coconino | Arizona | 4005 | 43213 | 456 |
2297867 | 2297867 | 2022-03-12 | Coconino | Arizona | 4005 | 43213 | 456 |
2294615 | 2294615 | 2022-03-11 | Coconino | Arizona | 4005 | 43213 | 456 |
2291363 | 2291363 | 2022-03-10 | Coconino | Arizona | 4005 | 43213 | 456 |
2288111 | 2288111 | 2022-03-09 | Coconino | Arizona | 4005 | 43213 | 456 |
2290799 | 2290799 | 2022-03-09 | Maverick | Texas | 48323 | 20682 | 456 |
2285915 | 2285915 | 2022-03-08 | Livingston | Louisiana | 22063 | 37019 | 456 |
2286063 | 2286063 | 2022-03-08 | Monroe | Michigan | 26115 | 37637 | 456 |
2287547 | 2287547 | 2022-03-08 | Maverick | Texas | 48323 | 20678 | 456 |
2282663 | 2282663 | 2022-03-07 | Livingston | Louisiana | 22063 | 37017 | 456 |
2282811 | 2282811 | 2022-03-07 | Monroe | Michigan | 26115 | 37637 | 456 |
2284295 | 2284295 | 2022-03-07 | Maverick | Texas | 48323 | 20677 | 456 |
2279410 | 2279410 | 2022-03-06 | Livingston | Louisiana | 22063 | 37008 | 456 |
2281043 | 2281043 | 2022-03-06 | Maverick | Texas | 48323 | 20673 | 456 |
2276157 | 2276157 | 2022-03-05 | Livingston | Louisiana | 22063 | 37008 | 456 |
2277790 | 2277790 | 2022-03-05 | Maverick | Texas | 48323 | 20668 | 456 |
2272904 | 2272904 | 2022-03-04 | Livingston | Louisiana | 22063 | 37008 | 456 |
2274604 | 2274604 | 2022-03-04 | Tom Green | Texas | 48451 | 40838 | 456 |
2269652 | 2269652 | 2022-03-03 | Livingston | Louisiana | 22063 | 37000 | 456 |
2269800 | 2269800 | 2022-03-03 | Monroe | Michigan | 26115 | 37575 | 456 |
2271513 | 2271513 | 2022-03-03 | Norfolk city | Virginia | 51710 | 41228 | 456 |
2266547 | 2266547 | 2022-03-02 | Monroe | Michigan | 26115 | 37575 | 456 |
2263913 | 2263913 | 2022-03-01 | Cabarrus | North Carolina | 37025 | 54947 | 456 |
2260662 | 2260662 | 2022-02-28 | Cabarrus | North Carolina | 37025 | 54933 | 456 |
2240367 | 2240367 | 2022-02-22 | Bossier | Louisiana | 22015 | 37213 | 456 |
2238232 | 2238232 | 2022-02-21 | Jackson | Oregon | 41029 | 41391 | 456 |
2234981 | 2234981 | 2022-02-20 | Jackson | Oregon | 41029 | 41391 | 456 |
2231730 | 2231730 | 2022-02-19 | Jackson | Oregon | 41029 | 41391 | 456 |
2228479 | 2228479 | 2022-02-18 | Jackson | Oregon | 41029 | 41391 | 456 |
2222168 | 2222168 | 2022-02-16 | Dorchester | South Carolina | 45035 | 55146 | 456 |
2217957 | 2217957 | 2022-02-15 | Rankin | Mississippi | 28121 | 35923 | 456 |
2213510 | 2213510 | 2022-02-14 | Larimer | Colorado | 8069 | 72117 | 456 |
2202849 | 2202849 | 2022-02-10 | Angelina | Texas | 48005 | 15126 | 456 |
2197015 | 2197015 | 2022-02-09 | Morgan | Alabama | 1103 | 34951 | 456 |
2193249 | 2193249 | 2022-02-07 | Midland | Texas | 48329 | 35650 | 456 |
2187237 | 2187237 | 2022-02-06 | Houston | Alabama | 1069 | 24126 | 456 |
2187868 | 2187868 | 2022-02-06 | McHenry | Illinois | 17111 | 72604 | 456 |
2189995 | 2189995 | 2022-02-06 | Midland | Texas | 48329 | 35619 | 456 |
2183984 | 2183984 | 2022-02-05 | Houston | Alabama | 1069 | 24126 | 456 |
2184615 | 2184615 | 2022-02-05 | McHenry | Illinois | 17111 | 72604 | 456 |
2180732 | 2180732 | 2022-02-04 | Houston | Alabama | 1069 | 24077 | 456 |
2181363 | 2181363 | 2022-02-04 | McHenry | Illinois | 17111 | 72604 | 456 |
2177885 | 2177885 | 2022-02-03 | Dougherty | Georgia | 13095 | 18627 | 456 |
2170859 | 2170859 | 2022-01-31 | Dane | Wisconsin | 55025 | 115276 | 456 |
2167606 | 2167606 | 2022-01-30 | Dane | Wisconsin | 55025 | 113727 | 456 |
2164351 | 2164351 | 2022-01-29 | Dane | Wisconsin | 55025 | 113727 | 456 |
2161096 | 2161096 | 2022-01-28 | Dane | Wisconsin | 55025 | 113727 | 456 |
2156974 | 2156974 | 2022-01-27 | Lebanon | Pennsylvania | 42075 | 34905 | 456 |
2150476 | 2150476 | 2022-01-25 | Monroe | Pennsylvania | 42089 | 34804 | 456 |
2145604 | 2145604 | 2022-01-24 | Tazewell | Illinois | 17179 | 33871 | 456 |
2147224 | 2147224 | 2022-01-24 | Monroe | Pennsylvania | 42089 | 34714 | 456 |
2147426 | 2147426 | 2022-01-24 | Minnehaha | South Dakota | 46099 | 54280 | 456 |
2143970 | 2143970 | 2022-01-23 | Monroe | Pennsylvania | 42089 | 34643 | 456 |
2140715 | 2140715 | 2022-01-22 | Monroe | Pennsylvania | 42089 | 34504 | 456 |
2124369 | 2124369 | 2022-01-17 | Clackamas | Oregon | 41005 | 44922 | 456 |
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);