ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,728 rows where county = "Warren" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state
- New Jersey 347
- Kentucky 346
- New York 346
- Ohio 344
- Iowa 340
- Pennsylvania 339
- Indiana 338
- Virginia 338
- Missouri 336
- Mississippi 335
- Georgia 334
- Tennessee 334
- North Carolina 329
- Illinois 322
fips
county
- Warren · 4,728 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1067027 | 1067027 | 2021-02-26 | Warren | Georgia | 13301 | 500 | 12 |
1067182 | 1067182 | 2021-02-26 | Warren | Illinois | 17187 | 1664 | 47 |
1067276 | 1067276 | 2021-02-26 | Warren | Indiana | 18171 | 755 | 13 |
1067374 | 1067374 | 2021-02-26 | Warren | Iowa | 19181 | 5002 | 74 |
1067602 | 1067602 | 2021-02-26 | Warren | Kentucky | 21227 | 14515 | 135 |
1067976 | 1067976 | 2021-02-26 | Warren | Mississippi | 28149 | 4122 | 113 |
1068095 | 1068095 | 2021-02-26 | Warren | Missouri | 29219 | 2650 | 27 |
1068299 | 1068299 | 2021-02-26 | Warren | New Jersey | 34041 | 6983 | 216 |
1068385 | 1068385 | 2021-02-26 | Warren | New York | 36113 | 2819 | 55 |
1068483 | 1068483 | 2021-02-26 | Warren | North Carolina | 37185 | 1582 | 18 |
1068629 | 1068629 | 2021-02-26 | Warren | Ohio | 39165 | 22294 | 272 |
1068810 | 1068810 | 2021-02-26 | Warren | Pennsylvania | 42123 | 2153 | 98 |
1069102 | 1069102 | 2021-02-26 | Warren | Tennessee | 47177 | 5304 | 75 |
1069535 | 1069535 | 2021-02-26 | Warren | Virginia | 51187 | 2275 | 44 |
1063782 | 1063782 | 2021-02-25 | Warren | Georgia | 13301 | 498 | 12 |
1063937 | 1063937 | 2021-02-25 | Warren | Illinois | 17187 | 1664 | 46 |
1064031 | 1064031 | 2021-02-25 | Warren | Indiana | 18171 | 754 | 13 |
1064129 | 1064129 | 2021-02-25 | Warren | Iowa | 19181 | 5002 | 72 |
1064357 | 1064357 | 2021-02-25 | Warren | Kentucky | 21227 | 14476 | 134 |
1064731 | 1064731 | 2021-02-25 | Warren | Mississippi | 28149 | 4114 | 113 |
1064850 | 1064850 | 2021-02-25 | Warren | Missouri | 29219 | 2646 | 27 |
1065054 | 1065054 | 2021-02-25 | Warren | New Jersey | 34041 | 6934 | 216 |
1065140 | 1065140 | 2021-02-25 | Warren | New York | 36113 | 2807 | 55 |
1065238 | 1065238 | 2021-02-25 | Warren | North Carolina | 37185 | 1577 | 18 |
1065384 | 1065384 | 2021-02-25 | Warren | Ohio | 39165 | 22244 | 270 |
1065565 | 1065565 | 2021-02-25 | Warren | Pennsylvania | 42123 | 2144 | 98 |
1065857 | 1065857 | 2021-02-25 | Warren | Tennessee | 47177 | 5303 | 75 |
1066290 | 1066290 | 2021-02-25 | Warren | Virginia | 51187 | 2268 | 44 |
1060537 | 1060537 | 2021-02-24 | Warren | Georgia | 13301 | 497 | 12 |
1060692 | 1060692 | 2021-02-24 | Warren | Illinois | 17187 | 1663 | 46 |
1060786 | 1060786 | 2021-02-24 | Warren | Indiana | 18171 | 749 | 13 |
1060884 | 1060884 | 2021-02-24 | Warren | Iowa | 19181 | 5002 | 71 |
1061112 | 1061112 | 2021-02-24 | Warren | Kentucky | 21227 | 14441 | 134 |
1061487 | 1061487 | 2021-02-24 | Warren | Mississippi | 28149 | 4101 | 113 |
1061606 | 1061606 | 2021-02-24 | Warren | Missouri | 29219 | 2646 | 27 |
1061810 | 1061810 | 2021-02-24 | Warren | New Jersey | 34041 | 6887 | 216 |
1061896 | 1061896 | 2021-02-24 | Warren | New York | 36113 | 2795 | 55 |
1061994 | 1061994 | 2021-02-24 | Warren | North Carolina | 37185 | 1568 | 18 |
1062140 | 1062140 | 2021-02-24 | Warren | Ohio | 39165 | 22166 | 270 |
1062320 | 1062320 | 2021-02-24 | Warren | Pennsylvania | 42123 | 2142 | 97 |
1062612 | 1062612 | 2021-02-24 | Warren | Tennessee | 47177 | 5298 | 75 |
1063045 | 1063045 | 2021-02-24 | Warren | Virginia | 51187 | 2260 | 42 |
1057291 | 1057291 | 2021-02-23 | Warren | Georgia | 13301 | 495 | 12 |
1057446 | 1057446 | 2021-02-23 | Warren | Illinois | 17187 | 1662 | 46 |
1057540 | 1057540 | 2021-02-23 | Warren | Indiana | 18171 | 748 | 13 |
1057638 | 1057638 | 2021-02-23 | Warren | Iowa | 19181 | 5002 | 70 |
1057866 | 1057866 | 2021-02-23 | Warren | Kentucky | 21227 | 14402 | 130 |
1058241 | 1058241 | 2021-02-23 | Warren | Mississippi | 28149 | 4091 | 113 |
1058360 | 1058360 | 2021-02-23 | Warren | Missouri | 29219 | 2629 | 22 |
1058564 | 1058564 | 2021-02-23 | Warren | New Jersey | 34041 | 6851 | 214 |
1058650 | 1058650 | 2021-02-23 | Warren | New York | 36113 | 2791 | 55 |
1058748 | 1058748 | 2021-02-23 | Warren | North Carolina | 37185 | 1567 | 18 |
1058894 | 1058894 | 2021-02-23 | Warren | Ohio | 39165 | 22137 | 269 |
1059075 | 1059075 | 2021-02-23 | Warren | Pennsylvania | 42123 | 2140 | 96 |
1059367 | 1059367 | 2021-02-23 | Warren | Tennessee | 47177 | 5294 | 75 |
1059800 | 1059800 | 2021-02-23 | Warren | Virginia | 51187 | 2253 | 42 |
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 |
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]);