ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "LaGrange", fips = 18087 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500323 | 2500323 | 2022-05-13 | LaGrange | Indiana | 18087 | 5871 | 102 |
2497065 | 2497065 | 2022-05-12 | LaGrange | Indiana | 18087 | 5871 | 102 |
2493807 | 2493807 | 2022-05-11 | LaGrange | Indiana | 18087 | 5871 | 102 |
2490549 | 2490549 | 2022-05-10 | LaGrange | Indiana | 18087 | 5869 | 102 |
2487292 | 2487292 | 2022-05-09 | LaGrange | Indiana | 18087 | 5869 | 102 |
2484034 | 2484034 | 2022-05-08 | LaGrange | Indiana | 18087 | 5860 | 102 |
2480776 | 2480776 | 2022-05-07 | LaGrange | Indiana | 18087 | 5860 | 102 |
2477518 | 2477518 | 2022-05-06 | LaGrange | Indiana | 18087 | 5860 | 102 |
2474260 | 2474260 | 2022-05-05 | LaGrange | Indiana | 18087 | 5860 | 102 |
2471003 | 2471003 | 2022-05-04 | LaGrange | Indiana | 18087 | 5860 | 102 |
2467747 | 2467747 | 2022-05-03 | LaGrange | Indiana | 18087 | 5855 | 102 |
2464492 | 2464492 | 2022-05-02 | LaGrange | Indiana | 18087 | 5855 | 102 |
2461236 | 2461236 | 2022-05-01 | LaGrange | Indiana | 18087 | 5851 | 102 |
2457980 | 2457980 | 2022-04-30 | LaGrange | Indiana | 18087 | 5851 | 102 |
2454724 | 2454724 | 2022-04-29 | LaGrange | Indiana | 18087 | 5851 | 102 |
2451468 | 2451468 | 2022-04-28 | LaGrange | Indiana | 18087 | 5848 | 102 |
2448212 | 2448212 | 2022-04-27 | LaGrange | Indiana | 18087 | 5848 | 102 |
2444956 | 2444956 | 2022-04-26 | LaGrange | Indiana | 18087 | 5846 | 102 |
2441700 | 2441700 | 2022-04-25 | LaGrange | Indiana | 18087 | 5846 | 102 |
2438444 | 2438444 | 2022-04-24 | LaGrange | Indiana | 18087 | 5845 | 102 |
2435188 | 2435188 | 2022-04-23 | LaGrange | Indiana | 18087 | 5845 | 102 |
2431932 | 2431932 | 2022-04-22 | LaGrange | Indiana | 18087 | 5845 | 102 |
2428676 | 2428676 | 2022-04-21 | LaGrange | Indiana | 18087 | 5845 | 102 |
2425420 | 2425420 | 2022-04-20 | LaGrange | Indiana | 18087 | 5845 | 102 |
2422164 | 2422164 | 2022-04-19 | LaGrange | Indiana | 18087 | 5844 | 102 |
2418908 | 2418908 | 2022-04-18 | LaGrange | Indiana | 18087 | 5844 | 102 |
2415652 | 2415652 | 2022-04-17 | LaGrange | Indiana | 18087 | 5842 | 102 |
2412396 | 2412396 | 2022-04-16 | LaGrange | Indiana | 18087 | 5842 | 102 |
2409140 | 2409140 | 2022-04-15 | LaGrange | Indiana | 18087 | 5842 | 102 |
2405884 | 2405884 | 2022-04-14 | LaGrange | Indiana | 18087 | 5842 | 102 |
2402629 | 2402629 | 2022-04-13 | LaGrange | Indiana | 18087 | 5842 | 102 |
2399374 | 2399374 | 2022-04-12 | LaGrange | Indiana | 18087 | 5842 | 102 |
2396119 | 2396119 | 2022-04-11 | LaGrange | Indiana | 18087 | 5842 | 102 |
2392863 | 2392863 | 2022-04-10 | LaGrange | Indiana | 18087 | 5842 | 102 |
2389607 | 2389607 | 2022-04-09 | LaGrange | Indiana | 18087 | 5842 | 102 |
2386352 | 2386352 | 2022-04-08 | LaGrange | Indiana | 18087 | 5842 | 102 |
2383097 | 2383097 | 2022-04-07 | LaGrange | Indiana | 18087 | 5842 | 102 |
2379842 | 2379842 | 2022-04-06 | LaGrange | Indiana | 18087 | 5842 | 102 |
2376588 | 2376588 | 2022-04-05 | LaGrange | Indiana | 18087 | 5843 | 102 |
2373336 | 2373336 | 2022-04-04 | LaGrange | Indiana | 18087 | 5843 | 102 |
2370083 | 2370083 | 2022-04-03 | LaGrange | Indiana | 18087 | 5843 | 102 |
2366830 | 2366830 | 2022-04-02 | LaGrange | Indiana | 18087 | 5843 | 102 |
2363577 | 2363577 | 2022-04-01 | LaGrange | Indiana | 18087 | 5843 | 102 |
2360323 | 2360323 | 2022-03-31 | LaGrange | Indiana | 18087 | 5843 | 102 |
2357069 | 2357069 | 2022-03-30 | LaGrange | Indiana | 18087 | 5843 | 102 |
2353816 | 2353816 | 2022-03-29 | LaGrange | Indiana | 18087 | 5849 | 102 |
2350564 | 2350564 | 2022-03-28 | LaGrange | Indiana | 18087 | 5849 | 102 |
2347311 | 2347311 | 2022-03-27 | LaGrange | Indiana | 18087 | 5849 | 102 |
2344058 | 2344058 | 2022-03-26 | LaGrange | Indiana | 18087 | 5849 | 102 |
2340805 | 2340805 | 2022-03-25 | LaGrange | Indiana | 18087 | 5849 | 102 |
2337552 | 2337552 | 2022-03-24 | LaGrange | Indiana | 18087 | 5849 | 102 |
2334298 | 2334298 | 2022-03-23 | LaGrange | Indiana | 18087 | 5848 | 102 |
2331044 | 2331044 | 2022-03-22 | LaGrange | Indiana | 18087 | 5847 | 102 |
2327792 | 2327792 | 2022-03-21 | LaGrange | Indiana | 18087 | 5847 | 102 |
2324539 | 2324539 | 2022-03-20 | LaGrange | Indiana | 18087 | 5847 | 102 |
2321285 | 2321285 | 2022-03-19 | LaGrange | Indiana | 18087 | 5847 | 102 |
2318031 | 2318031 | 2022-03-18 | LaGrange | Indiana | 18087 | 5847 | 102 |
2314778 | 2314778 | 2022-03-17 | LaGrange | Indiana | 18087 | 5847 | 102 |
2311525 | 2311525 | 2022-03-16 | LaGrange | Indiana | 18087 | 5846 | 102 |
2308272 | 2308272 | 2022-03-15 | LaGrange | Indiana | 18087 | 5846 | 102 |
2305021 | 2305021 | 2022-03-14 | LaGrange | Indiana | 18087 | 5846 | 102 |
2301769 | 2301769 | 2022-03-13 | LaGrange | Indiana | 18087 | 5845 | 102 |
2298517 | 2298517 | 2022-03-12 | LaGrange | Indiana | 18087 | 5845 | 102 |
2295265 | 2295265 | 2022-03-11 | LaGrange | Indiana | 18087 | 5845 | 102 |
2292013 | 2292013 | 2022-03-10 | LaGrange | Indiana | 18087 | 5843 | 102 |
2288761 | 2288761 | 2022-03-09 | LaGrange | Indiana | 18087 | 5842 | 102 |
2285510 | 2285510 | 2022-03-08 | LaGrange | Indiana | 18087 | 5840 | 102 |
2282258 | 2282258 | 2022-03-07 | LaGrange | Indiana | 18087 | 5840 | 102 |
2279005 | 2279005 | 2022-03-06 | LaGrange | Indiana | 18087 | 5839 | 102 |
2275752 | 2275752 | 2022-03-05 | LaGrange | Indiana | 18087 | 5839 | 102 |
2272499 | 2272499 | 2022-03-04 | LaGrange | Indiana | 18087 | 5839 | 102 |
2269247 | 2269247 | 2022-03-03 | LaGrange | Indiana | 18087 | 5838 | 102 |
2265994 | 2265994 | 2022-03-02 | LaGrange | Indiana | 18087 | 5837 | 102 |
2262743 | 2262743 | 2022-03-01 | LaGrange | Indiana | 18087 | 5834 | 102 |
2259492 | 2259492 | 2022-02-28 | LaGrange | Indiana | 18087 | 5831 | 102 |
2256241 | 2256241 | 2022-02-27 | LaGrange | Indiana | 18087 | 5827 | 102 |
2252990 | 2252990 | 2022-02-26 | LaGrange | Indiana | 18087 | 5827 | 102 |
2249739 | 2249739 | 2022-02-25 | LaGrange | Indiana | 18087 | 5827 | 102 |
2246488 | 2246488 | 2022-02-24 | LaGrange | Indiana | 18087 | 5825 | 102 |
2243237 | 2243237 | 2022-02-23 | LaGrange | Indiana | 18087 | 5825 | 102 |
2239986 | 2239986 | 2022-02-22 | LaGrange | Indiana | 18087 | 5825 | 100 |
2236735 | 2236735 | 2022-02-21 | LaGrange | Indiana | 18087 | 5825 | 100 |
2233484 | 2233484 | 2022-02-20 | LaGrange | Indiana | 18087 | 5824 | 100 |
2230233 | 2230233 | 2022-02-19 | LaGrange | Indiana | 18087 | 5824 | 100 |
2226982 | 2226982 | 2022-02-18 | LaGrange | Indiana | 18087 | 5824 | 100 |
2223731 | 2223731 | 2022-02-17 | LaGrange | Indiana | 18087 | 5822 | 100 |
2220480 | 2220480 | 2022-02-16 | LaGrange | Indiana | 18087 | 5819 | 100 |
2217229 | 2217229 | 2022-02-15 | LaGrange | Indiana | 18087 | 5817 | 100 |
2213978 | 2213978 | 2022-02-14 | LaGrange | Indiana | 18087 | 5816 | 99 |
2210726 | 2210726 | 2022-02-13 | LaGrange | Indiana | 18087 | 5810 | 99 |
2207473 | 2207473 | 2022-02-12 | LaGrange | Indiana | 18087 | 5810 | 99 |
2204220 | 2204220 | 2022-02-11 | LaGrange | Indiana | 18087 | 5810 | 99 |
2200967 | 2200967 | 2022-02-10 | LaGrange | Indiana | 18087 | 5806 | 99 |
2197713 | 2197713 | 2022-02-09 | LaGrange | Indiana | 18087 | 5795 | 99 |
2194459 | 2194459 | 2022-02-08 | LaGrange | Indiana | 18087 | 5795 | 99 |
2191205 | 2191205 | 2022-02-07 | LaGrange | Indiana | 18087 | 5784 | 99 |
2187952 | 2187952 | 2022-02-06 | LaGrange | Indiana | 18087 | 5774 | 99 |
2184699 | 2184699 | 2022-02-05 | LaGrange | Indiana | 18087 | 5774 | 99 |
2181447 | 2181447 | 2022-02-04 | LaGrange | Indiana | 18087 | 5774 | 99 |
2178196 | 2178196 | 2022-02-03 | LaGrange | Indiana | 18087 | 5767 | 99 |
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);