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

12,212 rows where county = "Wayne" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 16

fips 16

county 1

  • Wayne · 12,212 ✖
Link rowid date ▲ county state fips cases deaths
2500117 2500117 2022-05-13 Wayne Georgia 13305 7817 205
2500273 2500273 2022-05-13 Wayne Illinois 17191 5320 85
2500369 2500369 2022-05-13 Wayne Indiana 18177 18900 337
2500466 2500466 2022-05-13 Wayne Iowa 19185 1271 33
2500694 2500694 2022-05-13 Wayne Kentucky 21231 6107 92
2500903 2500903 2022-05-13 Wayne Michigan 26163 416604 7975
2501070 2501070 2022-05-13 Wayne Mississippi 28153 6008 87
2501189 2501189 2022-05-13 Wayne Missouri 29223 2406 53
2501339 2501339 2022-05-13 Wayne Nebraska 31179 1846 11
2501482 2501482 2022-05-13 Wayne New York 36117 18503 179
2501581 2501581 2022-05-13 Wayne North Carolina 37191 31560 405
2501729 2501729 2022-05-13 Wayne Ohio 39169 23392 439
2501910 2501910 2022-05-13 Wayne Pennsylvania 42127 10460 172
2502202 2502202 2022-05-13 Wayne Tennessee 47181 5700 72
2502490 2502490 2022-05-13 Wayne Utah 49055 444 0
2502732 2502732 2022-05-13 Wayne West Virginia 54099 9915 125
2496859 2496859 2022-05-12 Wayne Georgia 13305 7817 205
2497015 2497015 2022-05-12 Wayne Illinois 17191 5320 85
2497111 2497111 2022-05-12 Wayne Indiana 18177 18886 337
2497208 2497208 2022-05-12 Wayne Iowa 19185 1271 33
2497436 2497436 2022-05-12 Wayne Kentucky 21231 6107 92
2497645 2497645 2022-05-12 Wayne Michigan 26163 416604 7975
2497812 2497812 2022-05-12 Wayne Mississippi 28153 6008 87
2497931 2497931 2022-05-12 Wayne Missouri 29223 2406 53
2498081 2498081 2022-05-12 Wayne Nebraska 31179 1845 11
2498224 2498224 2022-05-12 Wayne New York 36117 18503 179
2498323 2498323 2022-05-12 Wayne North Carolina 37191 31560 405
2498471 2498471 2022-05-12 Wayne Ohio 39169 23392 439
2498652 2498652 2022-05-12 Wayne Pennsylvania 42127 10460 172
2498944 2498944 2022-05-12 Wayne Tennessee 47181 5700 72
2499232 2499232 2022-05-12 Wayne Utah 49055 444 0
2499474 2499474 2022-05-12 Wayne West Virginia 54099 9904 125
2493601 2493601 2022-05-11 Wayne Georgia 13305 7817 205
2493757 2493757 2022-05-11 Wayne Illinois 17191 5318 85
2493853 2493853 2022-05-11 Wayne Indiana 18177 18886 337
2493950 2493950 2022-05-11 Wayne Iowa 19185 1271 33
2494178 2494178 2022-05-11 Wayne Kentucky 21231 6107 92
2494387 2494387 2022-05-11 Wayne Michigan 26163 416604 7975
2494554 2494554 2022-05-11 Wayne Mississippi 28153 6008 87
2494673 2494673 2022-05-11 Wayne Missouri 29223 2406 53
2494823 2494823 2022-05-11 Wayne Nebraska 31179 1845 11
2494966 2494966 2022-05-11 Wayne New York 36117 18451 179
2495065 2495065 2022-05-11 Wayne North Carolina 37191 31560 405
2495213 2495213 2022-05-11 Wayne Ohio 39169 23288 438
2495394 2495394 2022-05-11 Wayne Pennsylvania 42127 10460 172
2495686 2495686 2022-05-11 Wayne Tennessee 47181 5700 72
2495974 2495974 2022-05-11 Wayne Utah 49055 444 0
2496216 2496216 2022-05-11 Wayne West Virginia 54099 9894 123
2490343 2490343 2022-05-10 Wayne Georgia 13305 7800 205
2490499 2490499 2022-05-10 Wayne Illinois 17191 5314 85
2490595 2490595 2022-05-10 Wayne Indiana 18177 18877 337
2490692 2490692 2022-05-10 Wayne Iowa 19185 1269 33
2490920 2490920 2022-05-10 Wayne Kentucky 21231 6107 92
2491129 2491129 2022-05-10 Wayne Michigan 26163 410946 7955
2491296 2491296 2022-05-10 Wayne Mississippi 28153 6008 87
2491415 2491415 2022-05-10 Wayne Missouri 29223 2406 53
2491565 2491565 2022-05-10 Wayne Nebraska 31179 1860 11
2491708 2491708 2022-05-10 Wayne New York 36117 18419 178
2491807 2491807 2022-05-10 Wayne North Carolina 37191 31400 405
2491955 2491955 2022-05-10 Wayne Ohio 39169 23288 438
2492136 2492136 2022-05-10 Wayne Pennsylvania 42127 10350 172
2492428 2492428 2022-05-10 Wayne Tennessee 47181 5697 72
2492716 2492716 2022-05-10 Wayne Utah 49055 443 0
2492958 2492958 2022-05-10 Wayne West Virginia 54099 9873 123
2487086 2487086 2022-05-09 Wayne Georgia 13305 7800 205
2487242 2487242 2022-05-09 Wayne Illinois 17191 5312 85
2487338 2487338 2022-05-09 Wayne Indiana 18177 18877 337
2487435 2487435 2022-05-09 Wayne Iowa 19185 1269 33
2487663 2487663 2022-05-09 Wayne Kentucky 21231 6107 92
2487872 2487872 2022-05-09 Wayne Michigan 26163 410946 7955
2488038 2488038 2022-05-09 Wayne Mississippi 28153 6008 87
2488157 2488157 2022-05-09 Wayne Missouri 29223 2406 53
2488307 2488307 2022-05-09 Wayne Nebraska 31179 1860 11
2488450 2488450 2022-05-09 Wayne New York 36117 18402 178
2488549 2488549 2022-05-09 Wayne North Carolina 37191 31400 405
2488697 2488697 2022-05-09 Wayne Ohio 39169 23288 438
2488878 2488878 2022-05-09 Wayne Pennsylvania 42127 10350 172
2489170 2489170 2022-05-09 Wayne Tennessee 47181 5697 72
2489458 2489458 2022-05-09 Wayne Utah 49055 443 0
2489700 2489700 2022-05-09 Wayne West Virginia 54099 9873 123
2483828 2483828 2022-05-08 Wayne Georgia 13305 7800 205
2483984 2483984 2022-05-08 Wayne Illinois 17191 5308 85
2484080 2484080 2022-05-08 Wayne Indiana 18177 18864 337
2484177 2484177 2022-05-08 Wayne Iowa 19185 1269 33
2484405 2484405 2022-05-08 Wayne Kentucky 21231 6098 91
2484614 2484614 2022-05-08 Wayne Michigan 26163 410946 7955
2484781 2484781 2022-05-08 Wayne Mississippi 28153 6004 87
2484900 2484900 2022-05-08 Wayne Missouri 29223 2406 53
2485050 2485050 2022-05-08 Wayne Nebraska 31179 1860 11
2485193 2485193 2022-05-08 Wayne New York 36117 18370 177
2485292 2485292 2022-05-08 Wayne North Carolina 37191 31400 405
2485440 2485440 2022-05-08 Wayne Ohio 39169 23288 438
2485621 2485621 2022-05-08 Wayne Pennsylvania 42127 10350 172
2485913 2485913 2022-05-08 Wayne Tennessee 47181 5697 72
2486200 2486200 2022-05-08 Wayne Utah 49055 442 0
2486443 2486443 2022-05-08 Wayne West Virginia 54099 9859 123
2480570 2480570 2022-05-07 Wayne Georgia 13305 7800 205
2480726 2480726 2022-05-07 Wayne Illinois 17191 5308 85
2480822 2480822 2022-05-07 Wayne Indiana 18177 18864 337
2480919 2480919 2022-05-07 Wayne Iowa 19185 1269 33

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