ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
5,289 rows where county = "Lewis" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 7
- Washington 776
- Tennessee 766
- New York 762
- Kentucky 761
- West Virginia 754
- Missouri 742
- Idaho 628
county 1
- Lewis · 5,189 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2455534 | 2455534 | 2022-04-29 | Lewis | Missouri | 29111 | 2745 | 35 |
2455851 | 2455851 | 2022-04-29 | Lewis | New York | 36049 | 6294 | 49 |
2456562 | 2456562 | 2022-04-29 | Lewis | Tennessee | 47101 | 3570 | 60 |
2457063 | 2457063 | 2022-04-29 | Lewis | Washington | 53041 | 17638 | 250 |
2457102 | 2457102 | 2022-04-29 | Lewis | West Virginia | 54041 | 5329 | 86 |
2451308 | 2451308 | 2022-04-28 | Lewis | Idaho | 16061 | 1134 | 29 |
2451791 | 2451791 | 2022-04-28 | Lewis | Kentucky | 21135 | 4522 | 84 |
2452278 | 2452278 | 2022-04-28 | Lewis | Missouri | 29111 | 2745 | 35 |
2452595 | 2452595 | 2022-04-28 | Lewis | New York | 36049 | 6275 | 49 |
2453306 | 2453306 | 2022-04-28 | Lewis | Tennessee | 47101 | 3570 | 60 |
2453807 | 2453807 | 2022-04-28 | Lewis | Washington | 53041 | 17614 | 249 |
2453846 | 2453846 | 2022-04-28 | Lewis | West Virginia | 54041 | 5326 | 86 |
2448052 | 2448052 | 2022-04-27 | Lewis | Idaho | 16061 | 1134 | 29 |
2448535 | 2448535 | 2022-04-27 | Lewis | Kentucky | 21135 | 4522 | 84 |
2449022 | 2449022 | 2022-04-27 | Lewis | Missouri | 29111 | 2745 | 35 |
2449339 | 2449339 | 2022-04-27 | Lewis | New York | 36049 | 6264 | 49 |
2450050 | 2450050 | 2022-04-27 | Lewis | Tennessee | 47101 | 3570 | 60 |
2450551 | 2450551 | 2022-04-27 | Lewis | Washington | 53041 | 17614 | 249 |
2450590 | 2450590 | 2022-04-27 | Lewis | West Virginia | 54041 | 5324 | 86 |
2444796 | 2444796 | 2022-04-26 | Lewis | Idaho | 16061 | 1134 | 29 |
2445279 | 2445279 | 2022-04-26 | Lewis | Kentucky | 21135 | 4522 | 84 |
2445765 | 2445765 | 2022-04-26 | Lewis | Missouri | 29111 | 2745 | 35 |
2446082 | 2446082 | 2022-04-26 | Lewis | New York | 36049 | 6253 | 49 |
2446793 | 2446793 | 2022-04-26 | Lewis | Tennessee | 47101 | 3570 | 60 |
2447295 | 2447295 | 2022-04-26 | Lewis | Washington | 53041 | 17595 | 248 |
2447334 | 2447334 | 2022-04-26 | Lewis | West Virginia | 54041 | 5323 | 86 |
2441540 | 2441540 | 2022-04-25 | Lewis | Idaho | 16061 | 1134 | 29 |
2442023 | 2442023 | 2022-04-25 | Lewis | Kentucky | 21135 | 4522 | 84 |
2442510 | 2442510 | 2022-04-25 | Lewis | Missouri | 29111 | 2745 | 35 |
2442827 | 2442827 | 2022-04-25 | Lewis | New York | 36049 | 6242 | 49 |
2443538 | 2443538 | 2022-04-25 | Lewis | Tennessee | 47101 | 3570 | 60 |
2444039 | 2444039 | 2022-04-25 | Lewis | Washington | 53041 | 17595 | 248 |
2444078 | 2444078 | 2022-04-25 | Lewis | West Virginia | 54041 | 5324 | 85 |
2438284 | 2438284 | 2022-04-24 | Lewis | Idaho | 16061 | 1134 | 29 |
2438767 | 2438767 | 2022-04-24 | Lewis | Kentucky | 21135 | 4517 | 84 |
2439254 | 2439254 | 2022-04-24 | Lewis | Missouri | 29111 | 2745 | 35 |
2439571 | 2439571 | 2022-04-24 | Lewis | New York | 36049 | 6240 | 49 |
2440282 | 2440282 | 2022-04-24 | Lewis | Tennessee | 47101 | 3570 | 60 |
2440783 | 2440783 | 2022-04-24 | Lewis | Washington | 53041 | 17572 | 248 |
2440822 | 2440822 | 2022-04-24 | Lewis | West Virginia | 54041 | 5321 | 85 |
2435028 | 2435028 | 2022-04-23 | Lewis | Idaho | 16061 | 1134 | 29 |
2435511 | 2435511 | 2022-04-23 | Lewis | Kentucky | 21135 | 4517 | 84 |
2435998 | 2435998 | 2022-04-23 | Lewis | Missouri | 29111 | 2745 | 35 |
2436315 | 2436315 | 2022-04-23 | Lewis | New York | 36049 | 6235 | 49 |
2437026 | 2437026 | 2022-04-23 | Lewis | Tennessee | 47101 | 3570 | 60 |
2437527 | 2437527 | 2022-04-23 | Lewis | Washington | 53041 | 17572 | 248 |
2437566 | 2437566 | 2022-04-23 | Lewis | West Virginia | 54041 | 5321 | 85 |
2431772 | 2431772 | 2022-04-22 | Lewis | Idaho | 16061 | 1134 | 29 |
2432255 | 2432255 | 2022-04-22 | Lewis | Kentucky | 21135 | 4517 | 84 |
2432742 | 2432742 | 2022-04-22 | Lewis | Missouri | 29111 | 2745 | 35 |
2433059 | 2433059 | 2022-04-22 | Lewis | New York | 36049 | 6230 | 49 |
2433770 | 2433770 | 2022-04-22 | Lewis | Tennessee | 47101 | 3570 | 60 |
2434271 | 2434271 | 2022-04-22 | Lewis | Washington | 53041 | 17572 | 248 |
2434310 | 2434310 | 2022-04-22 | Lewis | West Virginia | 54041 | 5321 | 85 |
2428516 | 2428516 | 2022-04-21 | Lewis | Idaho | 16061 | 1134 | 29 |
2428999 | 2428999 | 2022-04-21 | Lewis | Kentucky | 21135 | 4517 | 84 |
2429486 | 2429486 | 2022-04-21 | Lewis | Missouri | 29111 | 2745 | 35 |
2429803 | 2429803 | 2022-04-21 | Lewis | New York | 36049 | 6221 | 49 |
2430514 | 2430514 | 2022-04-21 | Lewis | Tennessee | 47101 | 3570 | 60 |
2431015 | 2431015 | 2022-04-21 | Lewis | Washington | 53041 | 17561 | 248 |
2431054 | 2431054 | 2022-04-21 | Lewis | West Virginia | 54041 | 5322 | 85 |
2425260 | 2425260 | 2022-04-20 | Lewis | Idaho | 16061 | 1134 | 29 |
2425743 | 2425743 | 2022-04-20 | Lewis | Kentucky | 21135 | 4517 | 84 |
2426230 | 2426230 | 2022-04-20 | Lewis | Missouri | 29111 | 2745 | 35 |
2426547 | 2426547 | 2022-04-20 | Lewis | New York | 36049 | 6219 | 49 |
2427258 | 2427258 | 2022-04-20 | Lewis | Tennessee | 47101 | 3570 | 60 |
2427759 | 2427759 | 2022-04-20 | Lewis | Washington | 53041 | 17561 | 248 |
2427798 | 2427798 | 2022-04-20 | Lewis | West Virginia | 54041 | 5320 | 85 |
2422004 | 2422004 | 2022-04-19 | Lewis | Idaho | 16061 | 1134 | 29 |
2422487 | 2422487 | 2022-04-19 | Lewis | Kentucky | 21135 | 4517 | 84 |
2422974 | 2422974 | 2022-04-19 | Lewis | Missouri | 29111 | 2745 | 35 |
2423291 | 2423291 | 2022-04-19 | Lewis | New York | 36049 | 6215 | 49 |
2424002 | 2424002 | 2022-04-19 | Lewis | Tennessee | 47101 | 3570 | 60 |
2424503 | 2424503 | 2022-04-19 | Lewis | Washington | 53041 | 17542 | 247 |
2424542 | 2424542 | 2022-04-19 | Lewis | West Virginia | 54041 | 5317 | 85 |
2418748 | 2418748 | 2022-04-18 | Lewis | Idaho | 16061 | 1134 | 29 |
2419231 | 2419231 | 2022-04-18 | Lewis | Kentucky | 21135 | 4517 | 84 |
2419717 | 2419717 | 2022-04-18 | Lewis | Missouri | 29111 | 2745 | 35 |
2420034 | 2420034 | 2022-04-18 | Lewis | New York | 36049 | 6208 | 49 |
2420746 | 2420746 | 2022-04-18 | Lewis | Tennessee | 47101 | 3570 | 60 |
2421247 | 2421247 | 2022-04-18 | Lewis | Washington | 53041 | 17542 | 247 |
2421286 | 2421286 | 2022-04-18 | Lewis | West Virginia | 54041 | 5316 | 85 |
2415492 | 2415492 | 2022-04-17 | Lewis | Idaho | 16061 | 1134 | 29 |
2415975 | 2415975 | 2022-04-17 | Lewis | Kentucky | 21135 | 4515 | 84 |
2416462 | 2416462 | 2022-04-17 | Lewis | Missouri | 29111 | 2745 | 35 |
2416779 | 2416779 | 2022-04-17 | Lewis | New York | 36049 | 6206 | 49 |
2417490 | 2417490 | 2022-04-17 | Lewis | Tennessee | 47101 | 3570 | 60 |
2417991 | 2417991 | 2022-04-17 | Lewis | Washington | 53041 | 17531 | 247 |
2418030 | 2418030 | 2022-04-17 | Lewis | West Virginia | 54041 | 5316 | 85 |
2412236 | 2412236 | 2022-04-16 | Lewis | Idaho | 16061 | 1134 | 29 |
2412719 | 2412719 | 2022-04-16 | Lewis | Kentucky | 21135 | 4515 | 84 |
2413206 | 2413206 | 2022-04-16 | Lewis | Missouri | 29111 | 2745 | 35 |
2413523 | 2413523 | 2022-04-16 | Lewis | New York | 36049 | 6198 | 49 |
2414234 | 2414234 | 2022-04-16 | Lewis | Tennessee | 47101 | 3570 | 60 |
2414735 | 2414735 | 2022-04-16 | Lewis | Washington | 53041 | 17531 | 247 |
2414774 | 2414774 | 2022-04-16 | Lewis | West Virginia | 54041 | 5316 | 85 |
2408980 | 2408980 | 2022-04-15 | Lewis | Idaho | 16061 | 1134 | 29 |
2409463 | 2409463 | 2022-04-15 | Lewis | Kentucky | 21135 | 4515 | 84 |
2409950 | 2409950 | 2022-04-15 | Lewis | Missouri | 29111 | 2745 | 35 |
2410267 | 2410267 | 2022-04-15 | Lewis | New York | 36049 | 6196 | 49 |
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] desc);