ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

4,728 rows where county = "Warren" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);