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 343
- Kentucky 342
- New York 342
- Ohio 340
- Iowa 336
- Pennsylvania 335
- Indiana 334
- Virginia 334
- Missouri 332
- Mississippi 331
- Georgia 330
- Tennessee 330
- North Carolina 325
- Illinois 318
fips 14
county 1
- Warren · 4,672 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054045 | 1054045 | 2021-02-22 | Warren | Georgia | 13301 | 491 | 12 |
1054200 | 1054200 | 2021-02-22 | Warren | Illinois | 17187 | 1662 | 46 |
1054294 | 1054294 | 2021-02-22 | Warren | Indiana | 18171 | 747 | 13 |
1054392 | 1054392 | 2021-02-22 | Warren | Iowa | 19181 | 5002 | 70 |
1054620 | 1054620 | 2021-02-22 | Warren | Kentucky | 21227 | 14356 | 130 |
1054995 | 1054995 | 2021-02-22 | Warren | Mississippi | 28149 | 4090 | 113 |
1055114 | 1055114 | 2021-02-22 | Warren | Missouri | 29219 | 2629 | 22 |
1055318 | 1055318 | 2021-02-22 | Warren | New Jersey | 34041 | 6815 | 213 |
1055404 | 1055404 | 2021-02-22 | Warren | New York | 36113 | 2776 | 53 |
1055502 | 1055502 | 2021-02-22 | Warren | North Carolina | 37185 | 1566 | 18 |
1055648 | 1055648 | 2021-02-22 | Warren | Ohio | 39165 | 22083 | 267 |
1055829 | 1055829 | 2021-02-22 | Warren | Pennsylvania | 42123 | 2135 | 96 |
1056121 | 1056121 | 2021-02-22 | Warren | Tennessee | 47177 | 5289 | 75 |
1056554 | 1056554 | 2021-02-22 | Warren | Virginia | 51187 | 2249 | 41 |
1050798 | 1050798 | 2021-02-21 | Warren | Georgia | 13301 | 491 | 11 |
1050953 | 1050953 | 2021-02-21 | Warren | Illinois | 17187 | 1661 | 46 |
1051047 | 1051047 | 2021-02-21 | Warren | Indiana | 18171 | 746 | 13 |
1051145 | 1051145 | 2021-02-21 | Warren | Iowa | 19181 | 5002 | 69 |
1051373 | 1051373 | 2021-02-21 | Warren | Kentucky | 21227 | 14339 | 130 |
1051748 | 1051748 | 2021-02-21 | Warren | Mississippi | 28149 | 4087 | 113 |
1051867 | 1051867 | 2021-02-21 | Warren | Missouri | 29219 | 2618 | 22 |
1052071 | 1052071 | 2021-02-21 | Warren | New Jersey | 34041 | 6795 | 213 |
1052158 | 1052158 | 2021-02-21 | Warren | New York | 36113 | 2769 | 53 |
1052256 | 1052256 | 2021-02-21 | Warren | North Carolina | 37185 | 1562 | 18 |
1052402 | 1052402 | 2021-02-21 | Warren | Ohio | 39165 | 22041 | 266 |
1052583 | 1052583 | 2021-02-21 | Warren | Pennsylvania | 42123 | 2132 | 96 |
1052875 | 1052875 | 2021-02-21 | Warren | Tennessee | 47177 | 5284 | 73 |
1053308 | 1053308 | 2021-02-21 | Warren | Virginia | 51187 | 2244 | 41 |
1047551 | 1047551 | 2021-02-20 | Warren | Georgia | 13301 | 490 | 11 |
1047706 | 1047706 | 2021-02-20 | Warren | Illinois | 17187 | 1658 | 46 |
1047800 | 1047800 | 2021-02-20 | Warren | Indiana | 18171 | 744 | 13 |
1047898 | 1047898 | 2021-02-20 | Warren | Iowa | 19181 | 5002 | 69 |
1048126 | 1048126 | 2021-02-20 | Warren | Kentucky | 21227 | 14310 | 130 |
1048501 | 1048501 | 2021-02-20 | Warren | Mississippi | 28149 | 4083 | 113 |
1048620 | 1048620 | 2021-02-20 | Warren | Missouri | 29219 | 2618 | 22 |
1048824 | 1048824 | 2021-02-20 | Warren | New Jersey | 34041 | 6768 | 213 |
1048911 | 1048911 | 2021-02-20 | Warren | New York | 36113 | 2763 | 53 |
1049009 | 1049009 | 2021-02-20 | Warren | North Carolina | 37185 | 1559 | 18 |
1049155 | 1049155 | 2021-02-20 | Warren | Ohio | 39165 | 21997 | 264 |
1049336 | 1049336 | 2021-02-20 | Warren | Pennsylvania | 42123 | 2132 | 96 |
1049628 | 1049628 | 2021-02-20 | Warren | Tennessee | 47177 | 5284 | 73 |
1050061 | 1050061 | 2021-02-20 | Warren | Virginia | 51187 | 2231 | 41 |
1044306 | 1044306 | 2021-02-19 | Warren | Georgia | 13301 | 488 | 11 |
1044461 | 1044461 | 2021-02-19 | Warren | Illinois | 17187 | 1657 | 46 |
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 |
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);