ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,566 rows where county = "LaSalle" 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 |
---|---|---|---|---|---|---|---|
2500225 | 2500225 | 2022-05-13 | LaSalle | Illinois | 17099 | 29734 | 442 |
2500726 | 2500726 | 2022-05-13 | LaSalle | Louisiana | 22059 | 4275 | 61 |
2496967 | 2496967 | 2022-05-12 | LaSalle | Illinois | 17099 | 29656 | 441 |
2497468 | 2497468 | 2022-05-12 | LaSalle | Louisiana | 22059 | 4273 | 61 |
2493709 | 2493709 | 2022-05-11 | LaSalle | Illinois | 17099 | 29627 | 441 |
2494210 | 2494210 | 2022-05-11 | LaSalle | Louisiana | 22059 | 4273 | 61 |
2490451 | 2490451 | 2022-05-10 | LaSalle | Illinois | 17099 | 29579 | 441 |
2490952 | 2490952 | 2022-05-10 | LaSalle | Louisiana | 22059 | 4273 | 61 |
2487194 | 2487194 | 2022-05-09 | LaSalle | Illinois | 17099 | 29528 | 441 |
2487695 | 2487695 | 2022-05-09 | LaSalle | Louisiana | 22059 | 4273 | 61 |
2483936 | 2483936 | 2022-05-08 | LaSalle | Illinois | 17099 | 29421 | 440 |
2484437 | 2484437 | 2022-05-08 | LaSalle | Louisiana | 22059 | 4270 | 60 |
2480678 | 2480678 | 2022-05-07 | LaSalle | Illinois | 17099 | 29421 | 440 |
2481179 | 2481179 | 2022-05-07 | LaSalle | Louisiana | 22059 | 4270 | 60 |
2477420 | 2477420 | 2022-05-06 | LaSalle | Illinois | 17099 | 29421 | 440 |
2477921 | 2477921 | 2022-05-06 | LaSalle | Louisiana | 22059 | 4270 | 60 |
2474162 | 2474162 | 2022-05-05 | LaSalle | Illinois | 17099 | 29364 | 440 |
2474663 | 2474663 | 2022-05-05 | LaSalle | Louisiana | 22059 | 4267 | 60 |
2470905 | 2470905 | 2022-05-04 | LaSalle | Illinois | 17099 | 29334 | 440 |
2471406 | 2471406 | 2022-05-04 | LaSalle | Louisiana | 22059 | 4265 | 60 |
2467649 | 2467649 | 2022-05-03 | LaSalle | Illinois | 17099 | 29287 | 440 |
2468150 | 2468150 | 2022-05-03 | LaSalle | Louisiana | 22059 | 4264 | 60 |
2464394 | 2464394 | 2022-05-02 | LaSalle | Illinois | 17099 | 29264 | 440 |
2464895 | 2464895 | 2022-05-02 | LaSalle | Louisiana | 22059 | 4264 | 60 |
2461138 | 2461138 | 2022-05-01 | LaSalle | Illinois | 17099 | 29216 | 440 |
2461639 | 2461639 | 2022-05-01 | LaSalle | Louisiana | 22059 | 4264 | 60 |
2457882 | 2457882 | 2022-04-30 | LaSalle | Illinois | 17099 | 29216 | 440 |
2458383 | 2458383 | 2022-04-30 | LaSalle | Louisiana | 22059 | 4264 | 60 |
2454626 | 2454626 | 2022-04-29 | LaSalle | Illinois | 17099 | 29216 | 440 |
2455127 | 2455127 | 2022-04-29 | LaSalle | Louisiana | 22059 | 4264 | 60 |
2451370 | 2451370 | 2022-04-28 | LaSalle | Illinois | 17099 | 29178 | 440 |
2451871 | 2451871 | 2022-04-28 | LaSalle | Louisiana | 22059 | 4254 | 60 |
2448114 | 2448114 | 2022-04-27 | LaSalle | Illinois | 17099 | 29159 | 439 |
2448615 | 2448615 | 2022-04-27 | LaSalle | Louisiana | 22059 | 4253 | 60 |
2444858 | 2444858 | 2022-04-26 | LaSalle | Illinois | 17099 | 29146 | 439 |
2445359 | 2445359 | 2022-04-26 | LaSalle | Louisiana | 22059 | 4253 | 60 |
2441602 | 2441602 | 2022-04-25 | LaSalle | Illinois | 17099 | 29131 | 439 |
2442103 | 2442103 | 2022-04-25 | LaSalle | Louisiana | 22059 | 4252 | 60 |
2438346 | 2438346 | 2022-04-24 | LaSalle | Illinois | 17099 | 29098 | 439 |
2438847 | 2438847 | 2022-04-24 | LaSalle | Louisiana | 22059 | 4251 | 59 |
2435090 | 2435090 | 2022-04-23 | LaSalle | Illinois | 17099 | 29098 | 439 |
2435591 | 2435591 | 2022-04-23 | LaSalle | Louisiana | 22059 | 4251 | 59 |
2431834 | 2431834 | 2022-04-22 | LaSalle | Illinois | 17099 | 29098 | 439 |
2432335 | 2432335 | 2022-04-22 | LaSalle | Louisiana | 22059 | 4251 | 59 |
2428578 | 2428578 | 2022-04-21 | LaSalle | Illinois | 17099 | 29083 | 439 |
2429079 | 2429079 | 2022-04-21 | LaSalle | Louisiana | 22059 | 4251 | 59 |
2425322 | 2425322 | 2022-04-20 | LaSalle | Illinois | 17099 | 29064 | 439 |
2425823 | 2425823 | 2022-04-20 | LaSalle | Louisiana | 22059 | 4249 | 59 |
2422066 | 2422066 | 2022-04-19 | LaSalle | Illinois | 17099 | 29042 | 439 |
2422567 | 2422567 | 2022-04-19 | LaSalle | Louisiana | 22059 | 4248 | 59 |
2418810 | 2418810 | 2022-04-18 | LaSalle | Illinois | 17099 | 29033 | 439 |
2419311 | 2419311 | 2022-04-18 | LaSalle | Louisiana | 22059 | 4248 | 59 |
2415554 | 2415554 | 2022-04-17 | LaSalle | Illinois | 17099 | 29012 | 439 |
2416055 | 2416055 | 2022-04-17 | LaSalle | Louisiana | 22059 | 4248 | 59 |
2412298 | 2412298 | 2022-04-16 | LaSalle | Illinois | 17099 | 29012 | 439 |
2412799 | 2412799 | 2022-04-16 | LaSalle | Louisiana | 22059 | 4248 | 59 |
2409042 | 2409042 | 2022-04-15 | LaSalle | Illinois | 17099 | 29012 | 439 |
2409543 | 2409543 | 2022-04-15 | LaSalle | Louisiana | 22059 | 4248 | 59 |
2405786 | 2405786 | 2022-04-14 | LaSalle | Illinois | 17099 | 28998 | 439 |
2406287 | 2406287 | 2022-04-14 | LaSalle | Louisiana | 22059 | 4248 | 59 |
2402531 | 2402531 | 2022-04-13 | LaSalle | Illinois | 17099 | 28985 | 439 |
2403031 | 2403031 | 2022-04-13 | LaSalle | Louisiana | 22059 | 4248 | 58 |
2399276 | 2399276 | 2022-04-12 | LaSalle | Illinois | 17099 | 28977 | 439 |
2399777 | 2399777 | 2022-04-12 | LaSalle | Louisiana | 22059 | 4246 | 58 |
2396021 | 2396021 | 2022-04-11 | LaSalle | Illinois | 17099 | 28969 | 438 |
2396521 | 2396521 | 2022-04-11 | LaSalle | Louisiana | 22059 | 4240 | 57 |
2392765 | 2392765 | 2022-04-10 | LaSalle | Illinois | 17099 | 28931 | 438 |
2393266 | 2393266 | 2022-04-10 | LaSalle | Louisiana | 22059 | 4238 | 57 |
2389509 | 2389509 | 2022-04-09 | LaSalle | Illinois | 17099 | 28931 | 438 |
2390010 | 2390010 | 2022-04-09 | LaSalle | Louisiana | 22059 | 4238 | 57 |
2386254 | 2386254 | 2022-04-08 | LaSalle | Illinois | 17099 | 28931 | 438 |
2386754 | 2386754 | 2022-04-08 | LaSalle | Louisiana | 22059 | 4238 | 57 |
2382999 | 2382999 | 2022-04-07 | LaSalle | Illinois | 17099 | 28908 | 437 |
2383499 | 2383499 | 2022-04-07 | LaSalle | Louisiana | 22059 | 4238 | 56 |
2379744 | 2379744 | 2022-04-06 | LaSalle | Illinois | 17099 | 28902 | 437 |
2380244 | 2380244 | 2022-04-06 | LaSalle | Louisiana | 22059 | 4229 | 56 |
2376490 | 2376490 | 2022-04-05 | LaSalle | Illinois | 17099 | 28888 | 437 |
2376989 | 2376989 | 2022-04-05 | LaSalle | Louisiana | 22059 | 4229 | 56 |
2373238 | 2373238 | 2022-04-04 | LaSalle | Illinois | 17099 | 28877 | 436 |
2373737 | 2373737 | 2022-04-04 | LaSalle | Louisiana | 22059 | 4225 | 56 |
2369985 | 2369985 | 2022-04-03 | LaSalle | Illinois | 17099 | 28864 | 436 |
2370484 | 2370484 | 2022-04-03 | LaSalle | Louisiana | 22059 | 4220 | 56 |
2366732 | 2366732 | 2022-04-02 | LaSalle | Illinois | 17099 | 28864 | 436 |
2367231 | 2367231 | 2022-04-02 | LaSalle | Louisiana | 22059 | 4220 | 56 |
2363479 | 2363479 | 2022-04-01 | LaSalle | Illinois | 17099 | 28864 | 436 |
2363978 | 2363978 | 2022-04-01 | LaSalle | Louisiana | 22059 | 4220 | 56 |
2360225 | 2360225 | 2022-03-31 | LaSalle | Illinois | 17099 | 28853 | 436 |
2360724 | 2360724 | 2022-03-31 | LaSalle | Louisiana | 22059 | 4219 | 56 |
2356971 | 2356971 | 2022-03-30 | LaSalle | Illinois | 17099 | 28844 | 436 |
2357470 | 2357470 | 2022-03-30 | LaSalle | Louisiana | 22059 | 4219 | 56 |
2353718 | 2353718 | 2022-03-29 | LaSalle | Illinois | 17099 | 28838 | 436 |
2354217 | 2354217 | 2022-03-29 | LaSalle | Louisiana | 22059 | 4217 | 56 |
2350466 | 2350466 | 2022-03-28 | LaSalle | Illinois | 17099 | 28829 | 436 |
2350965 | 2350965 | 2022-03-28 | LaSalle | Louisiana | 22059 | 4217 | 56 |
2347213 | 2347213 | 2022-03-27 | LaSalle | Illinois | 17099 | 28819 | 436 |
2347712 | 2347712 | 2022-03-27 | LaSalle | Louisiana | 22059 | 4215 | 56 |
2343960 | 2343960 | 2022-03-26 | LaSalle | Illinois | 17099 | 28819 | 436 |
2344459 | 2344459 | 2022-03-26 | LaSalle | Louisiana | 22059 | 4215 | 56 |
2340707 | 2340707 | 2022-03-25 | LaSalle | Illinois | 17099 | 28819 | 436 |
2341206 | 2341206 | 2022-03-25 | LaSalle | Louisiana | 22059 | 4215 | 56 |
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);