ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
10,902 rows where county = "Warren" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 14
- New Jersey 336
- Kentucky 335
- New York 335
- Ohio 333
- Iowa 329
- Pennsylvania 328
- Indiana 327
- Virginia 327
- Missouri 325
- Mississippi 324
- Tennessee 323
- Georgia 322
- North Carolina 318
- Illinois 310
fips 14
county 1
- Warren · 4,572 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1031574 | 1031574 | 2021-02-15 | Warren | Indiana | 18171 | 735 | 13 |
1031672 | 1031672 | 2021-02-15 | Warren | Iowa | 19181 | 4958 | 67 |
1031900 | 1031900 | 2021-02-15 | Warren | Kentucky | 21227 | 14137 | 127 |
1032275 | 1032275 | 2021-02-15 | Warren | Mississippi | 28149 | 4061 | 113 |
1032394 | 1032394 | 2021-02-15 | Warren | Missouri | 29219 | 2608 | 22 |
1032598 | 1032598 | 2021-02-15 | Warren | New Jersey | 34041 | 6626 | 209 |
1032684 | 1032684 | 2021-02-15 | Warren | New York | 36113 | 2710 | 53 |
1032782 | 1032782 | 2021-02-15 | Warren | North Carolina | 37185 | 1533 | 16 |
1032928 | 1032928 | 2021-02-15 | Warren | Ohio | 39165 | 21634 | 257 |
1033109 | 1033109 | 2021-02-15 | Warren | Pennsylvania | 42123 | 2107 | 95 |
1033401 | 1033401 | 2021-02-15 | Warren | Tennessee | 47177 | 5282 | 73 |
1033834 | 1033834 | 2021-02-15 | Warren | Virginia | 51187 | 2185 | 40 |
1028078 | 1028078 | 2021-02-14 | Warren | Georgia | 13301 | 487 | 10 |
1028233 | 1028233 | 2021-02-14 | Warren | Illinois | 17187 | 1655 | 46 |
1028327 | 1028327 | 2021-02-14 | Warren | Indiana | 18171 | 734 | 13 |
1028425 | 1028425 | 2021-02-14 | Warren | Iowa | 19181 | 4947 | 67 |
1028653 | 1028653 | 2021-02-14 | Warren | Kentucky | 21227 | 14113 | 127 |
1029028 | 1029028 | 2021-02-14 | Warren | Mississippi | 28149 | 4055 | 113 |
1029147 | 1029147 | 2021-02-14 | Warren | Missouri | 29219 | 2597 | 22 |
1029351 | 1029351 | 2021-02-14 | Warren | New Jersey | 34041 | 6612 | 209 |
1029438 | 1029438 | 2021-02-14 | Warren | New York | 36113 | 2704 | 53 |
1029536 | 1029536 | 2021-02-14 | Warren | North Carolina | 37185 | 1530 | 16 |
1029682 | 1029682 | 2021-02-14 | Warren | Ohio | 39165 | 21596 | 256 |
1029863 | 1029863 | 2021-02-14 | Warren | Pennsylvania | 42123 | 2105 | 95 |
1030155 | 1030155 | 2021-02-14 | Warren | Tennessee | 47177 | 5276 | 73 |
1030588 | 1030588 | 2021-02-14 | Warren | Virginia | 51187 | 2183 | 40 |
1024833 | 1024833 | 2021-02-13 | Warren | Georgia | 13301 | 487 | 10 |
1024988 | 1024988 | 2021-02-13 | Warren | Illinois | 17187 | 1654 | 46 |
1025082 | 1025082 | 2021-02-13 | Warren | Indiana | 18171 | 733 | 13 |
1025180 | 1025180 | 2021-02-13 | Warren | Iowa | 19181 | 4943 | 67 |
1025408 | 1025408 | 2021-02-13 | Warren | Kentucky | 21227 | 14063 | 127 |
1025782 | 1025782 | 2021-02-13 | Warren | Mississippi | 28149 | 4044 | 114 |
1025901 | 1025901 | 2021-02-13 | Warren | Missouri | 29219 | 2597 | 22 |
1026105 | 1026105 | 2021-02-13 | Warren | New Jersey | 34041 | 6598 | 209 |
1026191 | 1026191 | 2021-02-13 | Warren | New York | 36113 | 2680 | 53 |
1026289 | 1026289 | 2021-02-13 | Warren | North Carolina | 37185 | 1525 | 16 |
1026435 | 1026435 | 2021-02-13 | Warren | Ohio | 39165 | 21573 | 256 |
1026616 | 1026616 | 2021-02-13 | Warren | Pennsylvania | 42123 | 2103 | 95 |
1026908 | 1026908 | 2021-02-13 | Warren | Tennessee | 47177 | 5271 | 73 |
1027341 | 1027341 | 2021-02-13 | Warren | Virginia | 51187 | 2173 | 40 |
1021588 | 1021588 | 2021-02-12 | Warren | Georgia | 13301 | 487 | 10 |
1021743 | 1021743 | 2021-02-12 | Warren | Illinois | 17187 | 1653 | 46 |
1021837 | 1021837 | 2021-02-12 | Warren | Indiana | 18171 | 732 | 13 |
1021935 | 1021935 | 2021-02-12 | Warren | Iowa | 19181 | 4935 | 67 |
1022163 | 1022163 | 2021-02-12 | Warren | Kentucky | 21227 | 14029 | 127 |
1022537 | 1022537 | 2021-02-12 | Warren | Mississippi | 28149 | 4034 | 114 |
1022656 | 1022656 | 2021-02-12 | Warren | Missouri | 29219 | 2597 | 22 |
1022860 | 1022860 | 2021-02-12 | Warren | New Jersey | 34041 | 6563 | 209 |
1022946 | 1022946 | 2021-02-12 | Warren | New York | 36113 | 2667 | 53 |
1023044 | 1023044 | 2021-02-12 | Warren | North Carolina | 37185 | 1521 | 16 |
1023190 | 1023190 | 2021-02-12 | Warren | Ohio | 39165 | 21499 | 226 |
1023371 | 1023371 | 2021-02-12 | Warren | Pennsylvania | 42123 | 2091 | 95 |
1023663 | 1023663 | 2021-02-12 | Warren | Tennessee | 47177 | 5244 | 73 |
1024096 | 1024096 | 2021-02-12 | Warren | Virginia | 51187 | 2163 | 40 |
1018343 | 1018343 | 2021-02-11 | Warren | Georgia | 13301 | 487 | 10 |
1018498 | 1018498 | 2021-02-11 | Warren | Illinois | 17187 | 1652 | 46 |
1018592 | 1018592 | 2021-02-11 | Warren | Indiana | 18171 | 732 | 13 |
1018690 | 1018690 | 2021-02-11 | Warren | Iowa | 19181 | 4909 | 67 |
1018918 | 1018918 | 2021-02-11 | Warren | Kentucky | 21227 | 13962 | 123 |
1019292 | 1019292 | 2021-02-11 | Warren | Mississippi | 28149 | 4021 | 113 |
1019411 | 1019411 | 2021-02-11 | Warren | Missouri | 29219 | 2597 | 22 |
1019615 | 1019615 | 2021-02-11 | Warren | New Jersey | 34041 | 6530 | 209 |
1019701 | 1019701 | 2021-02-11 | Warren | New York | 36113 | 2654 | 53 |
1019799 | 1019799 | 2021-02-11 | Warren | North Carolina | 37185 | 1519 | 16 |
1019945 | 1019945 | 2021-02-11 | Warren | Ohio | 39165 | 21427 | 173 |
1020126 | 1020126 | 2021-02-11 | Warren | Pennsylvania | 42123 | 2089 | 95 |
1020418 | 1020418 | 2021-02-11 | Warren | Tennessee | 47177 | 5238 | 74 |
1020851 | 1020851 | 2021-02-11 | Warren | Virginia | 51187 | 2150 | 40 |
1015098 | 1015098 | 2021-02-10 | Warren | Georgia | 13301 | 486 | 10 |
1015253 | 1015253 | 2021-02-10 | Warren | Illinois | 17187 | 1650 | 46 |
1015347 | 1015347 | 2021-02-10 | Warren | Indiana | 18171 | 730 | 13 |
1015445 | 1015445 | 2021-02-10 | Warren | Iowa | 19181 | 4903 | 67 |
1015673 | 1015673 | 2021-02-10 | Warren | Kentucky | 21227 | 13913 | 123 |
1016047 | 1016047 | 2021-02-10 | Warren | Mississippi | 28149 | 4010 | 113 |
1016166 | 1016166 | 2021-02-10 | Warren | Missouri | 29219 | 2586 | 22 |
1016370 | 1016370 | 2021-02-10 | Warren | New Jersey | 34041 | 6491 | 207 |
1016456 | 1016456 | 2021-02-10 | Warren | New York | 36113 | 2630 | 53 |
1016554 | 1016554 | 2021-02-10 | Warren | North Carolina | 37185 | 1506 | 16 |
1016700 | 1016700 | 2021-02-10 | Warren | Ohio | 39165 | 21375 | 160 |
1016881 | 1016881 | 2021-02-10 | Warren | Pennsylvania | 42123 | 2086 | 95 |
1017173 | 1017173 | 2021-02-10 | Warren | Tennessee | 47177 | 5223 | 71 |
1017606 | 1017606 | 2021-02-10 | Warren | Virginia | 51187 | 2136 | 40 |
1011853 | 1011853 | 2021-02-09 | Warren | Georgia | 13301 | 483 | 10 |
1012008 | 1012008 | 2021-02-09 | Warren | Illinois | 17187 | 1649 | 46 |
1012102 | 1012102 | 2021-02-09 | Warren | Indiana | 18171 | 728 | 12 |
1012200 | 1012200 | 2021-02-09 | Warren | Iowa | 19181 | 4888 | 66 |
1012428 | 1012428 | 2021-02-09 | Warren | Kentucky | 21227 | 13860 | 118 |
1012802 | 1012802 | 2021-02-09 | Warren | Mississippi | 28149 | 4002 | 110 |
1012921 | 1012921 | 2021-02-09 | Warren | Missouri | 29219 | 2575 | 21 |
1013125 | 1013125 | 2021-02-09 | Warren | New Jersey | 34041 | 6456 | 205 |
1013211 | 1013211 | 2021-02-09 | Warren | New York | 36113 | 2620 | 53 |
1013309 | 1013309 | 2021-02-09 | Warren | North Carolina | 37185 | 1504 | 15 |
1013455 | 1013455 | 2021-02-09 | Warren | Ohio | 39165 | 21307 | 160 |
1013636 | 1013636 | 2021-02-09 | Warren | Pennsylvania | 42123 | 2075 | 95 |
1013928 | 1013928 | 2021-02-09 | Warren | Tennessee | 47177 | 5249 | 70 |
1014361 | 1014361 | 2021-02-09 | Warren | Virginia | 51187 | 2119 | 40 |
1008607 | 1008607 | 2021-02-08 | Warren | Georgia | 13301 | 482 | 10 |
1008762 | 1008762 | 2021-02-08 | Warren | Illinois | 17187 | 1646 | 46 |
1008856 | 1008856 | 2021-02-08 | Warren | Indiana | 18171 | 727 | 12 |
1008954 | 1008954 | 2021-02-08 | Warren | Iowa | 19181 | 4870 | 66 |
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);