ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,170 rows where deaths = 129 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 280
- Illinois 192
- Louisiana 182
- Georgia 163
- Indiana 160
- Ohio 147
- Tennessee 144
- Oklahoma 134
- New York 115
- Kentucky 108
- Michigan 107
- Alabama 104
- North Carolina 102
- West Virginia 102
- Pennsylvania 101
- Virginia 96
- South Carolina 87
- Missouri 85
- Mississippi 71
- Arkansas 60
- California 52
- Montana 51
- Wisconsin 51
- Iowa 43
- Maryland 43
- New Mexico 42
- Oregon 40
- Florida 39
- Nebraska 31
- Washington 29
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499581 | 2499581 | 2022-05-13 | Butler | Alabama | 1013 | 5068 | 129 |
2500346 | 2500346 | 2022-05-13 | Putnam | Indiana | 18133 | 9427 | 129 |
2501410 | 2501410 | 2022-05-13 | Luna | New Mexico | 35029 | 6725 | 129 |
2501480 | 2501480 | 2022-05-13 | Warren | New York | 36113 | 14739 | 129 |
2501547 | 2501547 | 2022-05-13 | Montgomery | North Carolina | 37123 | 7308 | 129 |
2502204 | 2502204 | 2022-05-13 | White | Tennessee | 47185 | 8249 | 129 |
2502375 | 2502375 | 2022-05-13 | Montague | Texas | 48337 | 4694 | 129 |
2502389 | 2502389 | 2022-05-13 | Panola | Texas | 48365 | 4609 | 129 |
2496323 | 2496323 | 2022-05-12 | Butler | Alabama | 1013 | 5068 | 129 |
2497088 | 2497088 | 2022-05-12 | Putnam | Indiana | 18133 | 9414 | 129 |
2497831 | 2497831 | 2022-05-12 | Callaway | Missouri | 29027 | 12120 | 129 |
2498152 | 2498152 | 2022-05-12 | Luna | New Mexico | 35029 | 6723 | 129 |
2498188 | 2498188 | 2022-05-12 | Greene | New York | 36039 | 9055 | 129 |
2498222 | 2498222 | 2022-05-12 | Warren | New York | 36113 | 14739 | 129 |
2498289 | 2498289 | 2022-05-12 | Montgomery | North Carolina | 37123 | 7308 | 129 |
2498946 | 2498946 | 2022-05-12 | White | Tennessee | 47185 | 8249 | 129 |
2499117 | 2499117 | 2022-05-12 | Montague | Texas | 48337 | 4692 | 129 |
2499131 | 2499131 | 2022-05-12 | Panola | Texas | 48365 | 4608 | 129 |
2493065 | 2493065 | 2022-05-11 | Butler | Alabama | 1013 | 5068 | 129 |
2493830 | 2493830 | 2022-05-11 | Putnam | Indiana | 18133 | 9414 | 129 |
2494573 | 2494573 | 2022-05-11 | Callaway | Missouri | 29027 | 12120 | 129 |
2494894 | 2494894 | 2022-05-11 | Luna | New Mexico | 35029 | 6722 | 129 |
2494930 | 2494930 | 2022-05-11 | Greene | New York | 36039 | 9044 | 129 |
2494964 | 2494964 | 2022-05-11 | Warren | New York | 36113 | 14693 | 129 |
2495031 | 2495031 | 2022-05-11 | Montgomery | North Carolina | 37123 | 7308 | 129 |
2495688 | 2495688 | 2022-05-11 | White | Tennessee | 47185 | 8249 | 129 |
2495859 | 2495859 | 2022-05-11 | Montague | Texas | 48337 | 4690 | 129 |
2495873 | 2495873 | 2022-05-11 | Panola | Texas | 48365 | 4605 | 129 |
2489807 | 2489807 | 2022-05-10 | Butler | Alabama | 1013 | 5068 | 129 |
2490572 | 2490572 | 2022-05-10 | Putnam | Indiana | 18133 | 9397 | 129 |
2491315 | 2491315 | 2022-05-10 | Callaway | Missouri | 29027 | 12120 | 129 |
2491672 | 2491672 | 2022-05-10 | Greene | New York | 36039 | 9025 | 129 |
2491706 | 2491706 | 2022-05-10 | Warren | New York | 36113 | 14635 | 129 |
2491773 | 2491773 | 2022-05-10 | Montgomery | North Carolina | 37123 | 7294 | 129 |
2492430 | 2492430 | 2022-05-10 | White | Tennessee | 47185 | 8244 | 129 |
2492601 | 2492601 | 2022-05-10 | Montague | Texas | 48337 | 4689 | 129 |
2492615 | 2492615 | 2022-05-10 | Panola | Texas | 48365 | 4605 | 129 |
2486550 | 2486550 | 2022-05-09 | Butler | Alabama | 1013 | 5068 | 129 |
2487315 | 2487315 | 2022-05-09 | Putnam | Indiana | 18133 | 9397 | 129 |
2488057 | 2488057 | 2022-05-09 | Callaway | Missouri | 29027 | 12120 | 129 |
2488414 | 2488414 | 2022-05-09 | Greene | New York | 36039 | 9017 | 129 |
2488448 | 2488448 | 2022-05-09 | Warren | New York | 36113 | 14616 | 129 |
2488515 | 2488515 | 2022-05-09 | Montgomery | North Carolina | 37123 | 7294 | 129 |
2489172 | 2489172 | 2022-05-09 | White | Tennessee | 47185 | 8244 | 129 |
2489343 | 2489343 | 2022-05-09 | Montague | Texas | 48337 | 4688 | 129 |
2489357 | 2489357 | 2022-05-09 | Panola | Texas | 48365 | 4605 | 129 |
2483292 | 2483292 | 2022-05-08 | Butler | Alabama | 1013 | 5067 | 129 |
2484057 | 2484057 | 2022-05-08 | Putnam | Indiana | 18133 | 9381 | 129 |
2484800 | 2484800 | 2022-05-08 | Callaway | Missouri | 29027 | 12120 | 129 |
2485157 | 2485157 | 2022-05-08 | Greene | New York | 36039 | 9012 | 129 |
2485191 | 2485191 | 2022-05-08 | Warren | New York | 36113 | 14588 | 129 |
2485258 | 2485258 | 2022-05-08 | Montgomery | North Carolina | 37123 | 7294 | 129 |
2485915 | 2485915 | 2022-05-08 | White | Tennessee | 47185 | 8244 | 129 |
2486086 | 2486086 | 2022-05-08 | Montague | Texas | 48337 | 4688 | 129 |
2486100 | 2486100 | 2022-05-08 | Panola | Texas | 48365 | 4605 | 129 |
2480034 | 2480034 | 2022-05-07 | Butler | Alabama | 1013 | 5067 | 129 |
2480799 | 2480799 | 2022-05-07 | Putnam | Indiana | 18133 | 9381 | 129 |
2481542 | 2481542 | 2022-05-07 | Callaway | Missouri | 29027 | 12120 | 129 |
2481899 | 2481899 | 2022-05-07 | Greene | New York | 36039 | 9002 | 129 |
2482000 | 2482000 | 2022-05-07 | Montgomery | North Carolina | 37123 | 7294 | 129 |
2482657 | 2482657 | 2022-05-07 | White | Tennessee | 47185 | 8244 | 129 |
2482828 | 2482828 | 2022-05-07 | Montague | Texas | 48337 | 4688 | 129 |
2482842 | 2482842 | 2022-05-07 | Panola | Texas | 48365 | 4605 | 129 |
2476776 | 2476776 | 2022-05-06 | Butler | Alabama | 1013 | 5067 | 129 |
2477541 | 2477541 | 2022-05-06 | Putnam | Indiana | 18133 | 9381 | 129 |
2478284 | 2478284 | 2022-05-06 | Callaway | Missouri | 29027 | 12120 | 129 |
2478641 | 2478641 | 2022-05-06 | Greene | New York | 36039 | 8990 | 129 |
2478742 | 2478742 | 2022-05-06 | Montgomery | North Carolina | 37123 | 7294 | 129 |
2479399 | 2479399 | 2022-05-06 | White | Tennessee | 47185 | 8244 | 129 |
2479570 | 2479570 | 2022-05-06 | Montague | Texas | 48337 | 4687 | 129 |
2479584 | 2479584 | 2022-05-06 | Panola | Texas | 48365 | 4605 | 129 |
2473518 | 2473518 | 2022-05-05 | Butler | Alabama | 1013 | 5067 | 129 |
2474124 | 2474124 | 2022-05-05 | Christian | Illinois | 17021 | 10291 | 129 |
2474283 | 2474283 | 2022-05-05 | Putnam | Indiana | 18133 | 9381 | 129 |
2475383 | 2475383 | 2022-05-05 | Greene | New York | 36039 | 8961 | 129 |
2475484 | 2475484 | 2022-05-05 | Montgomery | North Carolina | 37123 | 7294 | 129 |
2476141 | 2476141 | 2022-05-05 | White | Tennessee | 47185 | 8244 | 129 |
2476326 | 2476326 | 2022-05-05 | Panola | Texas | 48365 | 4604 | 129 |
2470261 | 2470261 | 2022-05-04 | Butler | Alabama | 1013 | 5067 | 129 |
2470867 | 2470867 | 2022-05-04 | Christian | Illinois | 17021 | 10289 | 129 |
2471026 | 2471026 | 2022-05-04 | Putnam | Indiana | 18133 | 9381 | 129 |
2472126 | 2472126 | 2022-05-04 | Greene | New York | 36039 | 8943 | 129 |
2472227 | 2472227 | 2022-05-04 | Montgomery | North Carolina | 37123 | 7294 | 129 |
2472884 | 2472884 | 2022-05-04 | White | Tennessee | 47185 | 8244 | 129 |
2473069 | 2473069 | 2022-05-04 | Panola | Texas | 48365 | 4603 | 129 |
2467005 | 2467005 | 2022-05-03 | Butler | Alabama | 1013 | 5066 | 129 |
2467502 | 2467502 | 2022-05-03 | Pierce | Georgia | 13229 | 5678 | 129 |
2467604 | 2467604 | 2022-05-03 | Boone | Illinois | 17007 | 13997 | 129 |
2467611 | 2467611 | 2022-05-03 | Christian | Illinois | 17021 | 10284 | 129 |
2467770 | 2467770 | 2022-05-03 | Putnam | Indiana | 18133 | 9370 | 129 |
2468870 | 2468870 | 2022-05-03 | Greene | New York | 36039 | 8921 | 129 |
2469628 | 2469628 | 2022-05-03 | White | Tennessee | 47185 | 8233 | 129 |
2469813 | 2469813 | 2022-05-03 | Panola | Texas | 48365 | 4601 | 129 |
2463750 | 2463750 | 2022-05-02 | Butler | Alabama | 1013 | 5066 | 129 |
2464247 | 2464247 | 2022-05-02 | Pierce | Georgia | 13229 | 5678 | 129 |
2464349 | 2464349 | 2022-05-02 | Boone | Illinois | 17007 | 13984 | 129 |
2464356 | 2464356 | 2022-05-02 | Christian | Illinois | 17021 | 10281 | 129 |
2464515 | 2464515 | 2022-05-02 | Putnam | Indiana | 18133 | 9370 | 129 |
2465614 | 2465614 | 2022-05-02 | Greene | New York | 36039 | 8914 | 129 |
2466372 | 2466372 | 2022-05-02 | White | Tennessee | 47185 | 8233 | 129 |
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);