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,238 rows where county = "Warren" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

  • Warren · 4,238 ✖
Link rowid date ▲ county state fips cases deaths
953511 953511 2021-01-22 Warren Georgia 13301 420 9
953665 953665 2021-01-22 Warren Illinois 17187 1596 44
953759 953759 2021-01-22 Warren Indiana 18171 679 8
953857 953857 2021-01-22 Warren Iowa 19181 4561 39
954085 954085 2021-01-22 Warren Kentucky 21227 12750 95
954460 954460 2021-01-22 Warren Mississippi 28149 3649 103
954579 954579 2021-01-22 Warren Missouri 29219 2375 20
954783 954783 2021-01-22 Warren New Jersey 34041 5626 193
954869 954869 2021-01-22 Warren New York 36113 2201 42
954967 954967 2021-01-22 Warren North Carolina 37185 1337 13
955113 955113 2021-01-22 Warren Ohio 39165 19552 140
955294 955294 2021-01-22 Warren Pennsylvania 42123 1921 80
955586 955586 2021-01-22 Warren Tennessee 47177 5044 54
956019 956019 2021-01-22 Warren Virginia 51187 1781 36
950266 950266 2021-01-21 Warren Georgia 13301 417 9
950420 950420 2021-01-21 Warren Illinois 17187 1591 44
950514 950514 2021-01-21 Warren Indiana 18171 677 8
950612 950612 2021-01-21 Warren Iowa 19181 4519 39
950840 950840 2021-01-21 Warren Kentucky 21227 12561 93
951215 951215 2021-01-21 Warren Mississippi 28149 3619 101
951334 951334 2021-01-21 Warren Missouri 29219 2357 20
951538 951538 2021-01-21 Warren New Jersey 34041 5568 191
951624 951624 2021-01-21 Warren New York 36113 2163 42
951722 951722 2021-01-21 Warren North Carolina 37185 1327 12
951868 951868 2021-01-21 Warren Ohio 39165 19436 140
952049 952049 2021-01-21 Warren Pennsylvania 42123 1906 78
952341 952341 2021-01-21 Warren Tennessee 47177 5033 54
952774 952774 2021-01-21 Warren Virginia 51187 1755 36
947020 947020 2021-01-20 Warren Georgia 13301 414 9
947174 947174 2021-01-20 Warren Illinois 17187 1588 44
947268 947268 2021-01-20 Warren Indiana 18171 665 8
947366 947366 2021-01-20 Warren Iowa 19181 4490 38
947594 947594 2021-01-20 Warren Kentucky 21227 12515 93
947969 947969 2021-01-20 Warren Mississippi 28149 3569 100
948088 948088 2021-01-20 Warren Missouri 29219 2357 20
948292 948292 2021-01-20 Warren New Jersey 34041 5525 191
948379 948379 2021-01-20 Warren New York 36113 2119 42
948477 948477 2021-01-20 Warren North Carolina 37185 1311 12
948623 948623 2021-01-20 Warren Ohio 39165 19222 140
948804 948804 2021-01-20 Warren Pennsylvania 42123 1889 75
949096 949096 2021-01-20 Warren Tennessee 47177 5026 53
949529 949529 2021-01-20 Warren Virginia 51187 1740 36
943773 943773 2021-01-19 Warren Georgia 13301 408 9
943927 943927 2021-01-19 Warren Illinois 17187 1586 44
944021 944021 2021-01-19 Warren Indiana 18171 665 8
944119 944119 2021-01-19 Warren Iowa 19181 4439 38
944347 944347 2021-01-19 Warren Kentucky 21227 12385 93
944722 944722 2021-01-19 Warren Mississippi 28149 3548 98
944841 944841 2021-01-19 Warren Missouri 29219 2352 20
945045 945045 2021-01-19 Warren New Jersey 34041 5475 189
945132 945132 2021-01-19 Warren New York 36113 2062 40
945231 945231 2021-01-19 Warren North Carolina 37185 1302 12
945377 945377 2021-01-19 Warren Ohio 39165 19083 140
945558 945558 2021-01-19 Warren Pennsylvania 42123 1872 73
945850 945850 2021-01-19 Warren Tennessee 47177 5000 53
946283 946283 2021-01-19 Warren Virginia 51187 1729 36
940528 940528 2021-01-18 Warren Georgia 13301 404 9
940682 940682 2021-01-18 Warren Illinois 17187 1582 44
940776 940776 2021-01-18 Warren Indiana 18171 662 8
940874 940874 2021-01-18 Warren Iowa 19181 4406 38
941102 941102 2021-01-18 Warren Kentucky 21227 12255 91
941477 941477 2021-01-18 Warren Mississippi 28149 3534 98
941596 941596 2021-01-18 Warren Missouri 29219 2287 19
941800 941800 2021-01-18 Warren New Jersey 34041 5430 189
941886 941886 2021-01-18 Warren New York 36113 2045 38
941984 941984 2021-01-18 Warren North Carolina 37185 1279 12
942130 942130 2021-01-18 Warren Ohio 39165 18974 139
942311 942311 2021-01-18 Warren Pennsylvania 42123 1869 73
942603 942603 2021-01-18 Warren Tennessee 47177 4987 53
943036 943036 2021-01-18 Warren Virginia 51187 1710 36
937283 937283 2021-01-17 Warren Georgia 13301 399 9
937437 937437 2021-01-17 Warren Illinois 17187 1580 43
937531 937531 2021-01-17 Warren Indiana 18171 660 8
937629 937629 2021-01-17 Warren Iowa 19181 4388 38
937857 937857 2021-01-17 Warren Kentucky 21227 12138 90
938232 938232 2021-01-17 Warren Mississippi 28149 3484 98
938351 938351 2021-01-17 Warren Missouri 29219 2287 19
938555 938555 2021-01-17 Warren New Jersey 34041 5376 189
938641 938641 2021-01-17 Warren New York 36113 2004 37
938739 938739 2021-01-17 Warren North Carolina 37185 1279 12
938885 938885 2021-01-17 Warren Ohio 39165 18917 139
939066 939066 2021-01-17 Warren Pennsylvania 42123 1849 70
939358 939358 2021-01-17 Warren Tennessee 47177 4975 53
939791 939791 2021-01-17 Warren Virginia 51187 1685 36
934038 934038 2021-01-16 Warren Georgia 13301 385 9
934192 934192 2021-01-16 Warren Illinois 17187 1577 43
934286 934286 2021-01-16 Warren Indiana 18171 655 8
934384 934384 2021-01-16 Warren Iowa 19181 4375 38
934612 934612 2021-01-16 Warren Kentucky 21227 12114 90
934987 934987 2021-01-16 Warren Mississippi 28149 3445 97
935106 935106 2021-01-16 Warren Missouri 29219 2287 19
935310 935310 2021-01-16 Warren New Jersey 34041 5326 189
935396 935396 2021-01-16 Warren New York 36113 1982 37
935494 935494 2021-01-16 Warren North Carolina 37185 1273 12
935640 935640 2021-01-16 Warren Ohio 39165 18792 139
935821 935821 2021-01-16 Warren Pennsylvania 42123 1845 69
936113 936113 2021-01-16 Warren Tennessee 47177 4962 53
936546 936546 2021-01-16 Warren Virginia 51187 1650 36
930793 930793 2021-01-15 Warren Georgia 13301 375 9
930947 930947 2021-01-15 Warren Illinois 17187 1575 43

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