ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,152 rows where deaths = 176 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 166
- Tennessee 149
- Mississippi 137
- Georgia 122
- Illinois 119
- Texas 112
- Arkansas 91
- North Carolina 88
- Ohio 78
- Wisconsin 78
- Michigan 74
- New Jersey 61
- Virginia 58
- West Virginia 58
- New York 57
- Kentucky 53
- Missouri 52
- Alabama 51
- Indiana 46
- South Carolina 43
- Oklahoma 39
- Louisiana 38
- Maryland 38
- Minnesota 36
- Arizona 35
- Rhode Island 28
- Florida 25
- California 22
- Colorado 22
- Nebraska 21
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499755 | 2499755 | 2022-05-13 | Union | Arkansas | 5139 | 9268 | 176 |
2500217 | 2500217 | 2022-05-13 | Jefferson | Illinois | 17081 | 11159 | 176 |
2500265 | 2500265 | 2022-05-13 | Stephenson | Illinois | 17177 | 11687 | 176 |
2500970 | 2500970 | 2022-05-13 | Rice | Minnesota | 27131 | 18357 | 176 |
2501130 | 2501130 | 2022-05-13 | Laclede | Missouri | 29105 | 8096 | 176 |
2501544 | 2501544 | 2022-05-13 | McDowell | North Carolina | 37111 | 13855 | 176 |
2501880 | 2501880 | 2022-05-13 | Juniata | Pennsylvania | 42067 | 4797 | 176 |
2502234 | 2502234 | 2022-05-13 | Caldwell | Texas | 48055 | 14339 | 176 |
2496497 | 2496497 | 2022-05-12 | Union | Arkansas | 5139 | 9267 | 176 |
2496959 | 2496959 | 2022-05-12 | Jefferson | Illinois | 17081 | 11155 | 176 |
2497007 | 2497007 | 2022-05-12 | Stephenson | Illinois | 17177 | 11662 | 176 |
2497712 | 2497712 | 2022-05-12 | Rice | Minnesota | 27131 | 18330 | 176 |
2497872 | 2497872 | 2022-05-12 | Laclede | Missouri | 29105 | 8089 | 176 |
2498286 | 2498286 | 2022-05-12 | McDowell | North Carolina | 37111 | 13855 | 176 |
2498622 | 2498622 | 2022-05-12 | Juniata | Pennsylvania | 42067 | 4797 | 176 |
2498976 | 2498976 | 2022-05-12 | Caldwell | Texas | 48055 | 14331 | 176 |
2493239 | 2493239 | 2022-05-11 | Union | Arkansas | 5139 | 9267 | 176 |
2493701 | 2493701 | 2022-05-11 | Jefferson | Illinois | 17081 | 11153 | 176 |
2493749 | 2493749 | 2022-05-11 | Stephenson | Illinois | 17177 | 11651 | 176 |
2494454 | 2494454 | 2022-05-11 | Rice | Minnesota | 27131 | 18307 | 176 |
2494614 | 2494614 | 2022-05-11 | Laclede | Missouri | 29105 | 8089 | 176 |
2495028 | 2495028 | 2022-05-11 | McDowell | North Carolina | 37111 | 13855 | 176 |
2495364 | 2495364 | 2022-05-11 | Juniata | Pennsylvania | 42067 | 4797 | 176 |
2495718 | 2495718 | 2022-05-11 | Caldwell | Texas | 48055 | 14320 | 176 |
2489981 | 2489981 | 2022-05-10 | Union | Arkansas | 5139 | 9264 | 176 |
2490443 | 2490443 | 2022-05-10 | Jefferson | Illinois | 17081 | 11148 | 176 |
2490491 | 2490491 | 2022-05-10 | Stephenson | Illinois | 17177 | 11631 | 176 |
2491196 | 2491196 | 2022-05-10 | Rice | Minnesota | 27131 | 18278 | 176 |
2491356 | 2491356 | 2022-05-10 | Laclede | Missouri | 29105 | 8089 | 176 |
2491770 | 2491770 | 2022-05-10 | McDowell | North Carolina | 37111 | 13821 | 176 |
2492106 | 2492106 | 2022-05-10 | Juniata | Pennsylvania | 42067 | 4781 | 176 |
2492426 | 2492426 | 2022-05-10 | Warren | Tennessee | 47177 | 13013 | 176 |
2492460 | 2492460 | 2022-05-10 | Caldwell | Texas | 48055 | 14313 | 176 |
2486724 | 2486724 | 2022-05-09 | Union | Arkansas | 5139 | 9264 | 176 |
2487186 | 2487186 | 2022-05-09 | Jefferson | Illinois | 17081 | 11146 | 176 |
2487234 | 2487234 | 2022-05-09 | Stephenson | Illinois | 17177 | 11620 | 176 |
2487939 | 2487939 | 2022-05-09 | Rice | Minnesota | 27131 | 18219 | 176 |
2488098 | 2488098 | 2022-05-09 | Laclede | Missouri | 29105 | 8089 | 176 |
2488512 | 2488512 | 2022-05-09 | McDowell | North Carolina | 37111 | 13821 | 176 |
2488848 | 2488848 | 2022-05-09 | Juniata | Pennsylvania | 42067 | 4781 | 176 |
2489168 | 2489168 | 2022-05-09 | Warren | Tennessee | 47177 | 13013 | 176 |
2489202 | 2489202 | 2022-05-09 | Caldwell | Texas | 48055 | 14306 | 176 |
2483466 | 2483466 | 2022-05-08 | Union | Arkansas | 5139 | 9264 | 176 |
2483928 | 2483928 | 2022-05-08 | Jefferson | Illinois | 17081 | 11143 | 176 |
2483976 | 2483976 | 2022-05-08 | Stephenson | Illinois | 17177 | 11601 | 176 |
2484681 | 2484681 | 2022-05-08 | Rice | Minnesota | 27131 | 18171 | 176 |
2484841 | 2484841 | 2022-05-08 | Laclede | Missouri | 29105 | 8089 | 176 |
2485255 | 2485255 | 2022-05-08 | McDowell | North Carolina | 37111 | 13821 | 176 |
2485591 | 2485591 | 2022-05-08 | Juniata | Pennsylvania | 42067 | 4781 | 176 |
2485911 | 2485911 | 2022-05-08 | Warren | Tennessee | 47177 | 13013 | 176 |
2485945 | 2485945 | 2022-05-08 | Caldwell | Texas | 48055 | 14305 | 176 |
2480208 | 2480208 | 2022-05-07 | Union | Arkansas | 5139 | 9263 | 176 |
2480670 | 2480670 | 2022-05-07 | Jefferson | Illinois | 17081 | 11143 | 176 |
2480718 | 2480718 | 2022-05-07 | Stephenson | Illinois | 17177 | 11601 | 176 |
2481423 | 2481423 | 2022-05-07 | Rice | Minnesota | 27131 | 18171 | 176 |
2481583 | 2481583 | 2022-05-07 | Laclede | Missouri | 29105 | 8089 | 176 |
2481997 | 2481997 | 2022-05-07 | McDowell | North Carolina | 37111 | 13821 | 176 |
2482333 | 2482333 | 2022-05-07 | Juniata | Pennsylvania | 42067 | 4781 | 176 |
2482653 | 2482653 | 2022-05-07 | Warren | Tennessee | 47177 | 13013 | 176 |
2482687 | 2482687 | 2022-05-07 | Caldwell | Texas | 48055 | 14298 | 176 |
2476950 | 2476950 | 2022-05-06 | Union | Arkansas | 5139 | 9261 | 176 |
2477412 | 2477412 | 2022-05-06 | Jefferson | Illinois | 17081 | 11143 | 176 |
2477460 | 2477460 | 2022-05-06 | Stephenson | Illinois | 17177 | 11601 | 176 |
2478165 | 2478165 | 2022-05-06 | Rice | Minnesota | 27131 | 18171 | 176 |
2478325 | 2478325 | 2022-05-06 | Laclede | Missouri | 29105 | 8089 | 176 |
2478739 | 2478739 | 2022-05-06 | McDowell | North Carolina | 37111 | 13821 | 176 |
2479075 | 2479075 | 2022-05-06 | Juniata | Pennsylvania | 42067 | 4781 | 176 |
2479395 | 2479395 | 2022-05-06 | Warren | Tennessee | 47177 | 13013 | 176 |
2479429 | 2479429 | 2022-05-06 | Caldwell | Texas | 48055 | 14290 | 176 |
2473692 | 2473692 | 2022-05-05 | Union | Arkansas | 5139 | 9259 | 176 |
2474154 | 2474154 | 2022-05-05 | Jefferson | Illinois | 17081 | 11134 | 176 |
2474202 | 2474202 | 2022-05-05 | Stephenson | Illinois | 17177 | 11582 | 176 |
2474907 | 2474907 | 2022-05-05 | Rice | Minnesota | 27131 | 18134 | 176 |
2475067 | 2475067 | 2022-05-05 | Laclede | Missouri | 29105 | 8102 | 176 |
2475481 | 2475481 | 2022-05-05 | McDowell | North Carolina | 37111 | 13821 | 176 |
2475817 | 2475817 | 2022-05-05 | Juniata | Pennsylvania | 42067 | 4781 | 176 |
2476137 | 2476137 | 2022-05-05 | Warren | Tennessee | 47177 | 13013 | 176 |
2476171 | 2476171 | 2022-05-05 | Caldwell | Texas | 48055 | 14285 | 176 |
2476564 | 2476564 | 2022-05-05 | Stafford | Virginia | 51179 | 30852 | 176 |
2470435 | 2470435 | 2022-05-04 | Union | Arkansas | 5139 | 9254 | 176 |
2470897 | 2470897 | 2022-05-04 | Jefferson | Illinois | 17081 | 11134 | 176 |
2470945 | 2470945 | 2022-05-04 | Stephenson | Illinois | 17177 | 11578 | 176 |
2471650 | 2471650 | 2022-05-04 | Rice | Minnesota | 27131 | 18103 | 176 |
2472224 | 2472224 | 2022-05-04 | McDowell | North Carolina | 37111 | 13821 | 176 |
2472560 | 2472560 | 2022-05-04 | Juniata | Pennsylvania | 42067 | 4781 | 176 |
2472880 | 2472880 | 2022-05-04 | Warren | Tennessee | 47177 | 13013 | 176 |
2472914 | 2472914 | 2022-05-04 | Caldwell | Texas | 48055 | 14279 | 176 |
2473306 | 2473306 | 2022-05-04 | Stafford | Virginia | 51179 | 30796 | 176 |
2467099 | 2467099 | 2022-05-03 | Graham | Arizona | 4009 | 11987 | 176 |
2467179 | 2467179 | 2022-05-03 | Union | Arkansas | 5139 | 9251 | 176 |
2467641 | 2467641 | 2022-05-03 | Jefferson | Illinois | 17081 | 11134 | 176 |
2467689 | 2467689 | 2022-05-03 | Stephenson | Illinois | 17177 | 11565 | 176 |
2468394 | 2468394 | 2022-05-03 | Rice | Minnesota | 27131 | 18085 | 176 |
2469304 | 2469304 | 2022-05-03 | Juniata | Pennsylvania | 42067 | 4779 | 176 |
2469624 | 2469624 | 2022-05-03 | Warren | Tennessee | 47177 | 13008 | 176 |
2469658 | 2469658 | 2022-05-03 | Caldwell | Texas | 48055 | 14275 | 176 |
2470050 | 2470050 | 2022-05-03 | Stafford | Virginia | 51179 | 30752 | 176 |
2463844 | 2463844 | 2022-05-02 | Graham | Arizona | 4009 | 11987 | 176 |
2463924 | 2463924 | 2022-05-02 | Union | Arkansas | 5139 | 9251 | 176 |
2464386 | 2464386 | 2022-05-02 | Jefferson | Illinois | 17081 | 11128 | 176 |
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);