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 340
- Kentucky 339
- New York 339
- Ohio 337
- Iowa 333
- Pennsylvania 332
- Indiana 331
- Virginia 331
- Missouri 329
- Mississippi 328
- Tennessee 327
- Georgia 326
- North Carolina 322
- Illinois 314
fips 14
county 1
- Warren · 4,628 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1044555 | 1044555 | 2021-02-19 | Warren | Indiana | 18171 | 743 | 13 |
1044653 | 1044653 | 2021-02-19 | Warren | Iowa | 19181 | 5002 | 69 |
1044881 | 1044881 | 2021-02-19 | Warren | Kentucky | 21227 | 14269 | 130 |
1045255 | 1045255 | 2021-02-19 | Warren | Mississippi | 28149 | 4083 | 113 |
1045374 | 1045374 | 2021-02-19 | Warren | Missouri | 29219 | 2618 | 22 |
1045578 | 1045578 | 2021-02-19 | Warren | New Jersey | 34041 | 6736 | 211 |
1045664 | 1045664 | 2021-02-19 | Warren | New York | 36113 | 2754 | 53 |
1045762 | 1045762 | 2021-02-19 | Warren | North Carolina | 37185 | 1557 | 18 |
1045908 | 1045908 | 2021-02-19 | Warren | Ohio | 39165 | 21875 | 264 |
1046089 | 1046089 | 2021-02-19 | Warren | Pennsylvania | 42123 | 2122 | 96 |
1046381 | 1046381 | 2021-02-19 | Warren | Tennessee | 47177 | 5282 | 73 |
1046814 | 1046814 | 2021-02-19 | Warren | Virginia | 51187 | 2226 | 40 |
1041061 | 1041061 | 2021-02-18 | Warren | Georgia | 13301 | 488 | 11 |
1041216 | 1041216 | 2021-02-18 | Warren | Illinois | 17187 | 1658 | 46 |
1041310 | 1041310 | 2021-02-18 | Warren | Indiana | 18171 | 739 | 13 |
1041408 | 1041408 | 2021-02-18 | Warren | Iowa | 19181 | 5001 | 69 |
1041636 | 1041636 | 2021-02-18 | Warren | Kentucky | 21227 | 14228 | 129 |
1042010 | 1042010 | 2021-02-18 | Warren | Mississippi | 28149 | 4080 | 113 |
1042129 | 1042129 | 2021-02-18 | Warren | Missouri | 29219 | 2613 | 22 |
1042333 | 1042333 | 2021-02-18 | Warren | New Jersey | 34041 | 6713 | 211 |
1042419 | 1042419 | 2021-02-18 | Warren | New York | 36113 | 2734 | 53 |
1042517 | 1042517 | 2021-02-18 | Warren | North Carolina | 37185 | 1551 | 18 |
1042663 | 1042663 | 2021-02-18 | Warren | Ohio | 39165 | 21806 | 264 |
1042844 | 1042844 | 2021-02-18 | Warren | Pennsylvania | 42123 | 2114 | 96 |
1043136 | 1043136 | 2021-02-18 | Warren | Tennessee | 47177 | 5281 | 73 |
1043569 | 1043569 | 2021-02-18 | Warren | Virginia | 51187 | 2213 | 40 |
1037816 | 1037816 | 2021-02-17 | Warren | Georgia | 13301 | 488 | 10 |
1037971 | 1037971 | 2021-02-17 | Warren | Illinois | 17187 | 1655 | 46 |
1038065 | 1038065 | 2021-02-17 | Warren | Indiana | 18171 | 738 | 13 |
1038163 | 1038163 | 2021-02-17 | Warren | Iowa | 19181 | 4981 | 69 |
1038391 | 1038391 | 2021-02-17 | Warren | Kentucky | 21227 | 14202 | 128 |
1038765 | 1038765 | 2021-02-17 | Warren | Mississippi | 28149 | 4080 | 113 |
1038884 | 1038884 | 2021-02-17 | Warren | Missouri | 29219 | 2608 | 22 |
1039088 | 1039088 | 2021-02-17 | Warren | New Jersey | 34041 | 6689 | 209 |
1039174 | 1039174 | 2021-02-17 | Warren | New York | 36113 | 2726 | 53 |
1039272 | 1039272 | 2021-02-17 | Warren | North Carolina | 37185 | 1545 | 18 |
1039418 | 1039418 | 2021-02-17 | Warren | Ohio | 39165 | 21748 | 260 |
1039599 | 1039599 | 2021-02-17 | Warren | Pennsylvania | 42123 | 2112 | 95 |
1039891 | 1039891 | 2021-02-17 | Warren | Tennessee | 47177 | 5282 | 73 |
1040324 | 1040324 | 2021-02-17 | Warren | Virginia | 51187 | 2205 | 40 |
1034571 | 1034571 | 2021-02-16 | Warren | Georgia | 13301 | 488 | 10 |
1034726 | 1034726 | 2021-02-16 | Warren | Illinois | 17187 | 1655 | 46 |
1034820 | 1034820 | 2021-02-16 | Warren | Indiana | 18171 | 736 | 13 |
1034918 | 1034918 | 2021-02-16 | Warren | Iowa | 19181 | 4965 | 69 |
1035146 | 1035146 | 2021-02-16 | Warren | Kentucky | 21227 | 14179 | 128 |
1035520 | 1035520 | 2021-02-16 | Warren | Mississippi | 28149 | 4073 | 113 |
1035639 | 1035639 | 2021-02-16 | Warren | Missouri | 29219 | 2608 | 22 |
1035843 | 1035843 | 2021-02-16 | Warren | New Jersey | 34041 | 6650 | 209 |
1035929 | 1035929 | 2021-02-16 | Warren | New York | 36113 | 2720 | 53 |
1036027 | 1036027 | 2021-02-16 | Warren | North Carolina | 37185 | 1538 | 16 |
1036173 | 1036173 | 2021-02-16 | Warren | Ohio | 39165 | 21702 | 259 |
1036354 | 1036354 | 2021-02-16 | Warren | Pennsylvania | 42123 | 2110 | 95 |
1036646 | 1036646 | 2021-02-16 | Warren | Tennessee | 47177 | 5282 | 73 |
1037079 | 1037079 | 2021-02-16 | Warren | Virginia | 51187 | 2195 | 40 |
1031325 | 1031325 | 2021-02-15 | Warren | Georgia | 13301 | 487 | 10 |
1031480 | 1031480 | 2021-02-15 | Warren | Illinois | 17187 | 1655 | 46 |
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 |
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);