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 333
- Kentucky 332
- New York 332
- Ohio 330
- Iowa 325
- Pennsylvania 325
- Virginia 324
- Indiana 323
- Missouri 322
- Mississippi 321
- Tennessee 320
- Georgia 319
- North Carolina 315
- Illinois 307
fips 14
county 1
- Warren · 4,528 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1009182 | 1009182 | 2021-02-08 | Warren | Kentucky | 21227 | 13788 | 117 |
1009557 | 1009557 | 2021-02-08 | Warren | Mississippi | 28149 | 3990 | 110 |
1009676 | 1009676 | 2021-02-08 | Warren | Missouri | 29219 | 2557 | 21 |
1009880 | 1009880 | 2021-02-08 | Warren | New Jersey | 34041 | 6421 | 205 |
1009966 | 1009966 | 2021-02-08 | Warren | New York | 36113 | 2606 | 53 |
1010064 | 1010064 | 2021-02-08 | Warren | North Carolina | 37185 | 1503 | 15 |
1010210 | 1010210 | 2021-02-08 | Warren | Ohio | 39165 | 21220 | 155 |
1010391 | 1010391 | 2021-02-08 | Warren | Pennsylvania | 42123 | 2072 | 95 |
1010683 | 1010683 | 2021-02-08 | Warren | Tennessee | 47177 | 5266 | 66 |
1011116 | 1011116 | 2021-02-08 | Warren | Virginia | 51187 | 2109 | 40 |
1005361 | 1005361 | 2021-02-07 | Warren | Georgia | 13301 | 482 | 10 |
1005516 | 1005516 | 2021-02-07 | Warren | Illinois | 17187 | 1645 | 46 |
1005610 | 1005610 | 2021-02-07 | Warren | Indiana | 18171 | 725 | 12 |
1005708 | 1005708 | 2021-02-07 | Warren | Iowa | 19181 | 4856 | 66 |
1005936 | 1005936 | 2021-02-07 | Warren | Kentucky | 21227 | 13751 | 114 |
1006310 | 1006310 | 2021-02-07 | Warren | Mississippi | 28149 | 3986 | 110 |
1006429 | 1006429 | 2021-02-07 | Warren | Missouri | 29219 | 2547 | 21 |
1006633 | 1006633 | 2021-02-07 | Warren | New Jersey | 34041 | 6394 | 205 |
1006720 | 1006720 | 2021-02-07 | Warren | New York | 36113 | 2596 | 51 |
1006818 | 1006818 | 2021-02-07 | Warren | North Carolina | 37185 | 1494 | 15 |
1006964 | 1006964 | 2021-02-07 | Warren | Ohio | 39165 | 21162 | 155 |
1007145 | 1007145 | 2021-02-07 | Warren | Pennsylvania | 42123 | 2069 | 95 |
1007437 | 1007437 | 2021-02-07 | Warren | Tennessee | 47177 | 5264 | 66 |
1007870 | 1007870 | 2021-02-07 | Warren | Virginia | 51187 | 2100 | 40 |
1002115 | 1002115 | 2021-02-06 | Warren | Georgia | 13301 | 480 | 10 |
1002270 | 1002270 | 2021-02-06 | Warren | Illinois | 17187 | 1645 | 46 |
1002364 | 1002364 | 2021-02-06 | Warren | Indiana | 18171 | 719 | 12 |
1002462 | 1002462 | 2021-02-06 | Warren | Iowa | 19181 | 4854 | 66 |
1002690 | 1002690 | 2021-02-06 | Warren | Kentucky | 21227 | 13715 | 112 |
1003064 | 1003064 | 2021-02-06 | Warren | Mississippi | 28149 | 3972 | 110 |
1003183 | 1003183 | 2021-02-06 | Warren | Missouri | 29219 | 2547 | 21 |
1003387 | 1003387 | 2021-02-06 | Warren | New Jersey | 34041 | 6350 | 205 |
1003474 | 1003474 | 2021-02-06 | Warren | New York | 36113 | 2582 | 48 |
1003572 | 1003572 | 2021-02-06 | Warren | North Carolina | 37185 | 1492 | 15 |
1003718 | 1003718 | 2021-02-06 | Warren | Ohio | 39165 | 21112 | 155 |
1003899 | 1003899 | 2021-02-06 | Warren | Pennsylvania | 42123 | 2054 | 95 |
1004191 | 1004191 | 2021-02-06 | Warren | Tennessee | 47177 | 5263 | 66 |
1004624 | 1004624 | 2021-02-06 | Warren | Virginia | 51187 | 2096 | 40 |
998869 | 998869 | 2021-02-05 | Warren | Georgia | 13301 | 478 | 10 |
999024 | 999024 | 2021-02-05 | Warren | Illinois | 17187 | 1644 | 46 |
999118 | 999118 | 2021-02-05 | Warren | Indiana | 18171 | 716 | 11 |
999216 | 999216 | 2021-02-05 | Warren | Iowa | 19181 | 4847 | 64 |
999444 | 999444 | 2021-02-05 | Warren | Kentucky | 21227 | 13657 | 107 |
999819 | 999819 | 2021-02-05 | Warren | Mississippi | 28149 | 3951 | 110 |
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);