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

8,074 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 · 8,074 ✖
Link rowid date ▲ county state fips cases deaths
1843147 1843147 2021-10-23 Warren Georgia 13301 763 24
1843303 1843303 2021-10-23 Warren Illinois 17187 2448 69
1843397 1843397 2021-10-23 Warren Indiana 18171 1214 18
1843495 1843495 2021-10-23 Warren Iowa 19181 7751 96
1843722 1843722 2021-10-23 Warren Kentucky 21227 25517 246
1844097 1844097 2021-10-23 Warren Mississippi 28149 6694 176
1844216 1844216 2021-10-23 Warren Missouri 29219 4987 45
1844421 1844421 2021-10-23 Warren New Jersey 34041 12061 253
1844507 1844507 2021-10-23 Warren New York 36113 5542 84
1844605 1844605 2021-10-23 Warren North Carolina 37185 2354 30
1844752 1844752 2021-10-23 Warren Ohio 39165 32836 377
1844933 1844933 2021-10-23 Warren Pennsylvania 42123 3916 123
1845225 1845225 2021-10-23 Warren Tennessee 47177 8568 119
1845658 1845658 2021-10-23 Warren Virginia 51187 4893 83
1839897 1839897 2021-10-22 Warren Georgia 13301 763 24
1840053 1840053 2021-10-22 Warren Illinois 17187 2448 69
1840147 1840147 2021-10-22 Warren Indiana 18171 1214 18
1840245 1840245 2021-10-22 Warren Iowa 19181 7751 96
1840472 1840472 2021-10-22 Warren Kentucky 21227 25517 246
1840847 1840847 2021-10-22 Warren Mississippi 28149 6694 176
1840966 1840966 2021-10-22 Warren Missouri 29219 4969 45
1841171 1841171 2021-10-22 Warren New Jersey 34041 12036 253
1841257 1841257 2021-10-22 Warren New York 36113 5501 84
1841355 1841355 2021-10-22 Warren North Carolina 37185 2354 30
1841502 1841502 2021-10-22 Warren Ohio 39165 32769 377
1841683 1841683 2021-10-22 Warren Pennsylvania 42123 3893 122
1841975 1841975 2021-10-22 Warren Tennessee 47177 8568 119
1842408 1842408 2021-10-22 Warren Virginia 51187 4893 83
1836648 1836648 2021-10-21 Warren Georgia 13301 763 23
1836804 1836804 2021-10-21 Warren Illinois 17187 2442 69
1836898 1836898 2021-10-21 Warren Indiana 18171 1213 18
1836996 1836996 2021-10-21 Warren Iowa 19181 7751 96
1837223 1837223 2021-10-21 Warren Kentucky 21227 25483 246
1837598 1837598 2021-10-21 Warren Mississippi 28149 6682 176
1837717 1837717 2021-10-21 Warren Missouri 29219 4963 45
1837922 1837922 2021-10-21 Warren New Jersey 34041 12003 253
1838008 1838008 2021-10-21 Warren New York 36113 5460 84
1838106 1838106 2021-10-21 Warren North Carolina 37185 2347 29
1838253 1838253 2021-10-21 Warren Ohio 39165 32687 373
1838434 1838434 2021-10-21 Warren Pennsylvania 42123 3869 122
1838726 1838726 2021-10-21 Warren Tennessee 47177 8556 117
1839159 1839159 2021-10-21 Warren Virginia 51187 4885 83
1833399 1833399 2021-10-20 Warren Georgia 13301 763 23
1833555 1833555 2021-10-20 Warren Illinois 17187 2440 69
1833649 1833649 2021-10-20 Warren Indiana 18171 1211 18
1833747 1833747 2021-10-20 Warren Iowa 19181 7751 96
1833974 1833974 2021-10-20 Warren Kentucky 21227 25440 246
1834349 1834349 2021-10-20 Warren Mississippi 28149 6679 176
1834468 1834468 2021-10-20 Warren Missouri 29219 4959 45
1834673 1834673 2021-10-20 Warren New Jersey 34041 11974 253
1834759 1834759 2021-10-20 Warren New York 36113 5428 84
1834857 1834857 2021-10-20 Warren North Carolina 37185 2349 28
1835004 1835004 2021-10-20 Warren Ohio 39165 32631 373
1835185 1835185 2021-10-20 Warren Pennsylvania 42123 3840 120
1835477 1835477 2021-10-20 Warren Tennessee 47177 8544 117
1835910 1835910 2021-10-20 Warren Virginia 51187 4872 83
1830150 1830150 2021-10-19 Warren Georgia 13301 762 23
1830306 1830306 2021-10-19 Warren Illinois 17187 2438 68
1830400 1830400 2021-10-19 Warren Indiana 18171 1209 18
1830498 1830498 2021-10-19 Warren Iowa 19181 7638 96
1830725 1830725 2021-10-19 Warren Kentucky 21227 25402 246
1831100 1831100 2021-10-19 Warren Mississippi 28149 6678 176
1831219 1831219 2021-10-19 Warren Missouri 29219 4955 45
1831424 1831424 2021-10-19 Warren New Jersey 34041 11952 253
1831510 1831510 2021-10-19 Warren New York 36113 5407 82
1831608 1831608 2021-10-19 Warren North Carolina 37185 2342 28
1831755 1831755 2021-10-19 Warren Ohio 39165 32526 373
1831936 1831936 2021-10-19 Warren Pennsylvania 42123 3779 118
1832228 1832228 2021-10-19 Warren Tennessee 47177 8524 116
1832661 1832661 2021-10-19 Warren Virginia 51187 4858 82
1826901 1826901 2021-10-18 Warren Georgia 13301 762 23
1827057 1827057 2021-10-18 Warren Illinois 17187 2436 68
1827151 1827151 2021-10-18 Warren Indiana 18171 1208 18
1827249 1827249 2021-10-18 Warren Iowa 19181 7638 96
1827476 1827476 2021-10-18 Warren Kentucky 21227 25348 244
1827851 1827851 2021-10-18 Warren Mississippi 28149 6656 176
1827970 1827970 2021-10-18 Warren Missouri 29219 4953 44
1828175 1828175 2021-10-18 Warren New Jersey 34041 11923 253
1828261 1828261 2021-10-18 Warren New York 36113 5386 82
1828359 1828359 2021-10-18 Warren North Carolina 37185 2335 28
1828506 1828506 2021-10-18 Warren Ohio 39165 32476 369
1828687 1828687 2021-10-18 Warren Pennsylvania 42123 3760 118
1828979 1828979 2021-10-18 Warren Tennessee 47177 8516 113
1829412 1829412 2021-10-18 Warren Virginia 51187 4845 81
1823652 1823652 2021-10-17 Warren Georgia 13301 762 23
1823808 1823808 2021-10-17 Warren Illinois 17187 2427 68
1823902 1823902 2021-10-17 Warren Indiana 18171 1204 18
1824000 1824000 2021-10-17 Warren Iowa 19181 7638 96
1824227 1824227 2021-10-17 Warren Kentucky 21227 25278 240
1824602 1824602 2021-10-17 Warren Mississippi 28149 6642 176
1824721 1824721 2021-10-17 Warren Missouri 29219 4953 44
1824926 1824926 2021-10-17 Warren New Jersey 34041 11899 253
1825012 1825012 2021-10-17 Warren New York 36113 5371 81
1825110 1825110 2021-10-17 Warren North Carolina 37185 2322 28
1825257 1825257 2021-10-17 Warren Ohio 39165 32425 369
1825438 1825438 2021-10-17 Warren Pennsylvania 42123 3759 117
1825730 1825730 2021-10-17 Warren Tennessee 47177 8493 113
1826163 1826163 2021-10-17 Warren Virginia 51187 4807 79
1820403 1820403 2021-10-16 Warren Georgia 13301 762 23
1820559 1820559 2021-10-16 Warren Illinois 17187 2427 68

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