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

779 rows where county = "LaSalle" and fips = 22059 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 22059 · 779 ✖

county 1

  • LaSalle · 779 ✖
Link rowid date ▲ county state fips cases deaths
2500726 2500726 2022-05-13 LaSalle Louisiana 22059 4275 61
2497468 2497468 2022-05-12 LaSalle Louisiana 22059 4273 61
2494210 2494210 2022-05-11 LaSalle Louisiana 22059 4273 61
2490952 2490952 2022-05-10 LaSalle Louisiana 22059 4273 61
2487695 2487695 2022-05-09 LaSalle Louisiana 22059 4273 61
2484437 2484437 2022-05-08 LaSalle Louisiana 22059 4270 60
2481179 2481179 2022-05-07 LaSalle Louisiana 22059 4270 60
2477921 2477921 2022-05-06 LaSalle Louisiana 22059 4270 60
2474663 2474663 2022-05-05 LaSalle Louisiana 22059 4267 60
2471406 2471406 2022-05-04 LaSalle Louisiana 22059 4265 60
2468150 2468150 2022-05-03 LaSalle Louisiana 22059 4264 60
2464895 2464895 2022-05-02 LaSalle Louisiana 22059 4264 60
2461639 2461639 2022-05-01 LaSalle Louisiana 22059 4264 60
2458383 2458383 2022-04-30 LaSalle Louisiana 22059 4264 60
2455127 2455127 2022-04-29 LaSalle Louisiana 22059 4264 60
2451871 2451871 2022-04-28 LaSalle Louisiana 22059 4254 60
2448615 2448615 2022-04-27 LaSalle Louisiana 22059 4253 60
2445359 2445359 2022-04-26 LaSalle Louisiana 22059 4253 60
2442103 2442103 2022-04-25 LaSalle Louisiana 22059 4252 60
2438847 2438847 2022-04-24 LaSalle Louisiana 22059 4251 59
2435591 2435591 2022-04-23 LaSalle Louisiana 22059 4251 59
2432335 2432335 2022-04-22 LaSalle Louisiana 22059 4251 59
2429079 2429079 2022-04-21 LaSalle Louisiana 22059 4251 59
2425823 2425823 2022-04-20 LaSalle Louisiana 22059 4249 59
2422567 2422567 2022-04-19 LaSalle Louisiana 22059 4248 59
2419311 2419311 2022-04-18 LaSalle Louisiana 22059 4248 59
2416055 2416055 2022-04-17 LaSalle Louisiana 22059 4248 59
2412799 2412799 2022-04-16 LaSalle Louisiana 22059 4248 59
2409543 2409543 2022-04-15 LaSalle Louisiana 22059 4248 59
2406287 2406287 2022-04-14 LaSalle Louisiana 22059 4248 59
2403031 2403031 2022-04-13 LaSalle Louisiana 22059 4248 58
2399777 2399777 2022-04-12 LaSalle Louisiana 22059 4246 58
2396521 2396521 2022-04-11 LaSalle Louisiana 22059 4240 57
2393266 2393266 2022-04-10 LaSalle Louisiana 22059 4238 57
2390010 2390010 2022-04-09 LaSalle Louisiana 22059 4238 57
2386754 2386754 2022-04-08 LaSalle Louisiana 22059 4238 57
2383499 2383499 2022-04-07 LaSalle Louisiana 22059 4238 56
2380244 2380244 2022-04-06 LaSalle Louisiana 22059 4229 56
2376989 2376989 2022-04-05 LaSalle Louisiana 22059 4229 56
2373737 2373737 2022-04-04 LaSalle Louisiana 22059 4225 56
2370484 2370484 2022-04-03 LaSalle Louisiana 22059 4220 56
2367231 2367231 2022-04-02 LaSalle Louisiana 22059 4220 56
2363978 2363978 2022-04-01 LaSalle Louisiana 22059 4220 56
2360724 2360724 2022-03-31 LaSalle Louisiana 22059 4219 56
2357470 2357470 2022-03-30 LaSalle Louisiana 22059 4219 56
2354217 2354217 2022-03-29 LaSalle Louisiana 22059 4217 56
2350965 2350965 2022-03-28 LaSalle Louisiana 22059 4217 56
2347712 2347712 2022-03-27 LaSalle Louisiana 22059 4215 56
2344459 2344459 2022-03-26 LaSalle Louisiana 22059 4215 56
2341206 2341206 2022-03-25 LaSalle Louisiana 22059 4215 56
2337953 2337953 2022-03-24 LaSalle Louisiana 22059 4215 56
2334699 2334699 2022-03-23 LaSalle Louisiana 22059 4215 56
2331445 2331445 2022-03-22 LaSalle Louisiana 22059 4214 56
2328193 2328193 2022-03-21 LaSalle Louisiana 22059 4206 56
2324940 2324940 2022-03-20 LaSalle Louisiana 22059 4202 56
2321686 2321686 2022-03-19 LaSalle Louisiana 22059 4202 56
2318432 2318432 2022-03-18 LaSalle Louisiana 22059 4202 56
2315179 2315179 2022-03-17 LaSalle Louisiana 22059 4198 56
2311926 2311926 2022-03-16 LaSalle Louisiana 22059 4196 56
2308673 2308673 2022-03-15 LaSalle Louisiana 22059 4196 56
2305422 2305422 2022-03-14 LaSalle Louisiana 22059 4196 53
2302170 2302170 2022-03-13 LaSalle Louisiana 22059 4193 53
2298918 2298918 2022-03-12 LaSalle Louisiana 22059 4193 53
2295666 2295666 2022-03-11 LaSalle Louisiana 22059 4193 53
2292414 2292414 2022-03-10 LaSalle Louisiana 22059 4192 53
2289162 2289162 2022-03-09 LaSalle Louisiana 22059 4192 53
2285911 2285911 2022-03-08 LaSalle Louisiana 22059 4192 53
2282659 2282659 2022-03-07 LaSalle Louisiana 22059 4192 53
2279406 2279406 2022-03-06 LaSalle Louisiana 22059 4188 53
2276153 2276153 2022-03-05 LaSalle Louisiana 22059 4188 53
2272900 2272900 2022-03-04 LaSalle Louisiana 22059 4188 53
2269648 2269648 2022-03-03 LaSalle Louisiana 22059 4183 53
2266395 2266395 2022-03-02 LaSalle Louisiana 22059 4183 52
2263144 2263144 2022-03-01 LaSalle Louisiana 22059 4171 52
2259893 2259893 2022-02-28 LaSalle Louisiana 22059 4171 52
2256642 2256642 2022-02-27 LaSalle Louisiana 22059 4171 52
2253391 2253391 2022-02-26 LaSalle Louisiana 22059 4171 52
2250140 2250140 2022-02-25 LaSalle Louisiana 22059 4171 52
2246889 2246889 2022-02-24 LaSalle Louisiana 22059 4169 52
2243638 2243638 2022-02-23 LaSalle Louisiana 22059 4155 51
2240387 2240387 2022-02-22 LaSalle Louisiana 22059 4144 51
2237136 2237136 2022-02-21 LaSalle Louisiana 22059 4140 51
2233885 2233885 2022-02-20 LaSalle Louisiana 22059 4130 51
2230634 2230634 2022-02-19 LaSalle Louisiana 22059 4130 51
2227383 2227383 2022-02-18 LaSalle Louisiana 22059 4130 51
2224132 2224132 2022-02-17 LaSalle Louisiana 22059 4125 50
2220881 2220881 2022-02-16 LaSalle Louisiana 22059 4118 49
2217630 2217630 2022-02-15 LaSalle Louisiana 22059 4111 49
2214379 2214379 2022-02-14 LaSalle Louisiana 22059 4107 49
2211127 2211127 2022-02-13 LaSalle Louisiana 22059 4091 49
2207874 2207874 2022-02-12 LaSalle Louisiana 22059 4091 49
2204621 2204621 2022-02-11 LaSalle Louisiana 22059 4091 49
2201368 2201368 2022-02-10 LaSalle Louisiana 22059 4081 49
2198114 2198114 2022-02-09 LaSalle Louisiana 22059 4064 49
2194860 2194860 2022-02-08 LaSalle Louisiana 22059 4056 49
2191606 2191606 2022-02-07 LaSalle Louisiana 22059 4051 49
2188353 2188353 2022-02-06 LaSalle Louisiana 22059 4006 49
2185100 2185100 2022-02-05 LaSalle Louisiana 22059 4006 49
2181848 2181848 2022-02-04 LaSalle Louisiana 22059 4006 49
2178597 2178597 2022-02-03 LaSalle Louisiana 22059 3990 49

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