ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,657 rows where county = "Lafayette" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Lafayette · 4,557 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449020 | 2449020 | 2022-04-27 | Lafayette | Missouri | 29107 | 7793 | 128 |
2450657 | 2450657 | 2022-04-27 | Lafayette | Wisconsin | 55065 | 3682 | 24 |
2444355 | 2444355 | 2022-04-26 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2444563 | 2444563 | 2022-04-26 | Lafayette | Florida | 12067 | 2779 | 61 |
2445360 | 2445360 | 2022-04-26 | Lafayette | Louisiana | 22055 | 62598 | 500 |
2445661 | 2445661 | 2022-04-26 | Lafayette | Mississippi | 28071 | 15299 | 179 |
2445763 | 2445763 | 2022-04-26 | Lafayette | Missouri | 29107 | 7793 | 128 |
2447401 | 2447401 | 2022-04-26 | Lafayette | Wisconsin | 55065 | 3682 | 24 |
2441099 | 2441099 | 2022-04-25 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2441307 | 2441307 | 2022-04-25 | Lafayette | Florida | 12067 | 2779 | 61 |
2442104 | 2442104 | 2022-04-25 | Lafayette | Louisiana | 22055 | 62596 | 500 |
2442405 | 2442405 | 2022-04-25 | Lafayette | Mississippi | 28071 | 15287 | 179 |
2442508 | 2442508 | 2022-04-25 | Lafayette | Missouri | 29107 | 7793 | 128 |
2444145 | 2444145 | 2022-04-25 | Lafayette | Wisconsin | 55065 | 3681 | 24 |
2437843 | 2437843 | 2022-04-24 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2438051 | 2438051 | 2022-04-24 | Lafayette | Florida | 12067 | 2779 | 61 |
2438848 | 2438848 | 2022-04-24 | Lafayette | Louisiana | 22055 | 62587 | 500 |
2439149 | 2439149 | 2022-04-24 | Lafayette | Mississippi | 28071 | 15287 | 179 |
2439252 | 2439252 | 2022-04-24 | Lafayette | Missouri | 29107 | 7793 | 128 |
2440889 | 2440889 | 2022-04-24 | Lafayette | Wisconsin | 55065 | 3673 | 24 |
2434587 | 2434587 | 2022-04-23 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2434795 | 2434795 | 2022-04-23 | Lafayette | Florida | 12067 | 2779 | 61 |
2435592 | 2435592 | 2022-04-23 | Lafayette | Louisiana | 22055 | 62587 | 500 |
2435893 | 2435893 | 2022-04-23 | Lafayette | Mississippi | 28071 | 15287 | 179 |
2435996 | 2435996 | 2022-04-23 | Lafayette | Missouri | 29107 | 7793 | 128 |
2437633 | 2437633 | 2022-04-23 | Lafayette | Wisconsin | 55065 | 3673 | 24 |
2431331 | 2431331 | 2022-04-22 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2431539 | 2431539 | 2022-04-22 | Lafayette | Florida | 12067 | 2779 | 61 |
2432336 | 2432336 | 2022-04-22 | Lafayette | Louisiana | 22055 | 62587 | 500 |
2432637 | 2432637 | 2022-04-22 | Lafayette | Mississippi | 28071 | 15287 | 179 |
2432740 | 2432740 | 2022-04-22 | Lafayette | Missouri | 29107 | 7793 | 128 |
2434377 | 2434377 | 2022-04-22 | Lafayette | Wisconsin | 55065 | 3673 | 24 |
2428075 | 2428075 | 2022-04-21 | Lafayette | Arkansas | 5073 | 1296 | 31 |
2428283 | 2428283 | 2022-04-21 | Lafayette | Florida | 12067 | 2776 | 61 |
2429080 | 2429080 | 2022-04-21 | Lafayette | Louisiana | 22055 | 62584 | 500 |
2429381 | 2429381 | 2022-04-21 | Lafayette | Mississippi | 28071 | 15287 | 179 |
2429484 | 2429484 | 2022-04-21 | Lafayette | Missouri | 29107 | 7793 | 128 |
2431121 | 2431121 | 2022-04-21 | Lafayette | Wisconsin | 55065 | 3672 | 24 |
2424819 | 2424819 | 2022-04-20 | Lafayette | Arkansas | 5073 | 1296 | 31 |
2425027 | 2425027 | 2022-04-20 | Lafayette | Florida | 12067 | 2776 | 61 |
2425824 | 2425824 | 2022-04-20 | Lafayette | Louisiana | 22055 | 62583 | 499 |
2426125 | 2426125 | 2022-04-20 | Lafayette | Mississippi | 28071 | 15287 | 179 |
2426228 | 2426228 | 2022-04-20 | Lafayette | Missouri | 29107 | 7793 | 128 |
2427865 | 2427865 | 2022-04-20 | Lafayette | Wisconsin | 55065 | 3665 | 24 |
2421563 | 2421563 | 2022-04-19 | Lafayette | Arkansas | 5073 | 1296 | 31 |
2421771 | 2421771 | 2022-04-19 | Lafayette | Florida | 12067 | 2776 | 61 |
2422568 | 2422568 | 2022-04-19 | Lafayette | Louisiana | 22055 | 62574 | 499 |
2422869 | 2422869 | 2022-04-19 | Lafayette | Mississippi | 28071 | 15287 | 179 |
2422972 | 2422972 | 2022-04-19 | Lafayette | Missouri | 29107 | 7793 | 128 |
2424609 | 2424609 | 2022-04-19 | Lafayette | Wisconsin | 55065 | 3661 | 24 |
2418307 | 2418307 | 2022-04-18 | Lafayette | Arkansas | 5073 | 1296 | 31 |
2418515 | 2418515 | 2022-04-18 | Lafayette | Florida | 12067 | 2776 | 61 |
2419312 | 2419312 | 2022-04-18 | Lafayette | Louisiana | 22055 | 62572 | 499 |
2419613 | 2419613 | 2022-04-18 | Lafayette | Mississippi | 28071 | 15287 | 179 |
2419715 | 2419715 | 2022-04-18 | Lafayette | Missouri | 29107 | 7793 | 128 |
2421353 | 2421353 | 2022-04-18 | Lafayette | Wisconsin | 55065 | 3660 | 24 |
2415051 | 2415051 | 2022-04-17 | Lafayette | Arkansas | 5073 | 1296 | 31 |
2415259 | 2415259 | 2022-04-17 | Lafayette | Florida | 12067 | 2776 | 61 |
2416056 | 2416056 | 2022-04-17 | Lafayette | Louisiana | 22055 | 62559 | 499 |
2416357 | 2416357 | 2022-04-17 | Lafayette | Mississippi | 28071 | 15273 | 178 |
2416460 | 2416460 | 2022-04-17 | Lafayette | Missouri | 29107 | 7793 | 128 |
2418097 | 2418097 | 2022-04-17 | Lafayette | Wisconsin | 55065 | 3659 | 24 |
2411795 | 2411795 | 2022-04-16 | Lafayette | Arkansas | 5073 | 1296 | 31 |
2412003 | 2412003 | 2022-04-16 | Lafayette | Florida | 12067 | 2776 | 61 |
2412800 | 2412800 | 2022-04-16 | Lafayette | Louisiana | 22055 | 62559 | 499 |
2413101 | 2413101 | 2022-04-16 | Lafayette | Mississippi | 28071 | 15273 | 178 |
2413204 | 2413204 | 2022-04-16 | Lafayette | Missouri | 29107 | 7793 | 128 |
2414841 | 2414841 | 2022-04-16 | Lafayette | Wisconsin | 55065 | 3659 | 24 |
2408539 | 2408539 | 2022-04-15 | Lafayette | Arkansas | 5073 | 1296 | 31 |
2408747 | 2408747 | 2022-04-15 | Lafayette | Florida | 12067 | 2776 | 61 |
2409544 | 2409544 | 2022-04-15 | Lafayette | Louisiana | 22055 | 62559 | 499 |
2409845 | 2409845 | 2022-04-15 | Lafayette | Mississippi | 28071 | 15273 | 178 |
2409948 | 2409948 | 2022-04-15 | Lafayette | Missouri | 29107 | 7793 | 128 |
2411585 | 2411585 | 2022-04-15 | Lafayette | Wisconsin | 55065 | 3659 | 24 |
2405283 | 2405283 | 2022-04-14 | Lafayette | Arkansas | 5073 | 1296 | 31 |
2405491 | 2405491 | 2022-04-14 | Lafayette | Florida | 12067 | 2776 | 61 |
2406288 | 2406288 | 2022-04-14 | Lafayette | Louisiana | 22055 | 62559 | 499 |
2406589 | 2406589 | 2022-04-14 | Lafayette | Mississippi | 28071 | 15273 | 178 |
2406692 | 2406692 | 2022-04-14 | Lafayette | Missouri | 29107 | 7793 | 128 |
2408329 | 2408329 | 2022-04-14 | Lafayette | Wisconsin | 55065 | 3659 | 24 |
2402028 | 2402028 | 2022-04-13 | Lafayette | Arkansas | 5073 | 1296 | 31 |
2402236 | 2402236 | 2022-04-13 | Lafayette | Florida | 12067 | 2776 | 61 |
2403032 | 2403032 | 2022-04-13 | Lafayette | Louisiana | 22055 | 62332 | 499 |
2403333 | 2403333 | 2022-04-13 | Lafayette | Mississippi | 28071 | 15273 | 178 |
2403436 | 2403436 | 2022-04-13 | Lafayette | Missouri | 29107 | 7793 | 128 |
2405073 | 2405073 | 2022-04-13 | Lafayette | Wisconsin | 55065 | 3656 | 24 |
2398773 | 2398773 | 2022-04-12 | Lafayette | Arkansas | 5073 | 1296 | 31 |
2398981 | 2398981 | 2022-04-12 | Lafayette | Florida | 12067 | 2776 | 60 |
2399778 | 2399778 | 2022-04-12 | Lafayette | Louisiana | 22055 | 62328 | 499 |
2400079 | 2400079 | 2022-04-12 | Lafayette | Mississippi | 28071 | 15273 | 178 |
2400181 | 2400181 | 2022-04-12 | Lafayette | Missouri | 29107 | 7793 | 128 |
2401818 | 2401818 | 2022-04-12 | Lafayette | Wisconsin | 55065 | 3640 | 24 |
2395518 | 2395518 | 2022-04-11 | Lafayette | Arkansas | 5073 | 1296 | 31 |
2395726 | 2395726 | 2022-04-11 | Lafayette | Florida | 12067 | 2776 | 60 |
2396522 | 2396522 | 2022-04-11 | Lafayette | Louisiana | 22055 | 62324 | 498 |
2396823 | 2396823 | 2022-04-11 | Lafayette | Mississippi | 28071 | 15230 | 178 |
2396926 | 2396926 | 2022-04-11 | Lafayette | Missouri | 29107 | 7793 | 128 |
2398563 | 2398563 | 2022-04-11 | Lafayette | Wisconsin | 55065 | 3639 | 22 |
2392262 | 2392262 | 2022-04-10 | Lafayette | Arkansas | 5073 | 1296 | 31 |
2392470 | 2392470 | 2022-04-10 | Lafayette | Florida | 12067 | 2776 | 60 |
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);