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

781 rows where county = "Lawrence" and state = "Indiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Indiana · 781 ✖

fips 1

county 1

  • Lawrence · 781 ✖
Link rowid date ▲ county state fips cases deaths
2500326 2500326 2022-05-13 Lawrence Indiana 18093 12021 261
2497068 2497068 2022-05-12 Lawrence Indiana 18093 12000 261
2493810 2493810 2022-05-11 Lawrence Indiana 18093 12000 261
2490552 2490552 2022-05-10 Lawrence Indiana 18093 11993 261
2487295 2487295 2022-05-09 Lawrence Indiana 18093 11993 261
2484037 2484037 2022-05-08 Lawrence Indiana 18093 11950 260
2480779 2480779 2022-05-07 Lawrence Indiana 18093 11950 260
2477521 2477521 2022-05-06 Lawrence Indiana 18093 11950 260
2474263 2474263 2022-05-05 Lawrence Indiana 18093 11950 260
2471006 2471006 2022-05-04 Lawrence Indiana 18093 11950 260
2467750 2467750 2022-05-03 Lawrence Indiana 18093 11944 260
2464495 2464495 2022-05-02 Lawrence Indiana 18093 11944 260
2461239 2461239 2022-05-01 Lawrence Indiana 18093 11941 260
2457983 2457983 2022-04-30 Lawrence Indiana 18093 11941 260
2454727 2454727 2022-04-29 Lawrence Indiana 18093 11941 260
2451471 2451471 2022-04-28 Lawrence Indiana 18093 11922 259
2448215 2448215 2022-04-27 Lawrence Indiana 18093 11922 259
2444959 2444959 2022-04-26 Lawrence Indiana 18093 11910 259
2441703 2441703 2022-04-25 Lawrence Indiana 18093 11910 259
2438447 2438447 2022-04-24 Lawrence Indiana 18093 11885 259
2435191 2435191 2022-04-23 Lawrence Indiana 18093 11885 259
2431935 2431935 2022-04-22 Lawrence Indiana 18093 11885 259
2428679 2428679 2022-04-21 Lawrence Indiana 18093 11877 259
2425423 2425423 2022-04-20 Lawrence Indiana 18093 11877 259
2422167 2422167 2022-04-19 Lawrence Indiana 18093 11866 259
2418911 2418911 2022-04-18 Lawrence Indiana 18093 11866 259
2415655 2415655 2022-04-17 Lawrence Indiana 18093 11853 259
2412399 2412399 2022-04-16 Lawrence Indiana 18093 11853 259
2409143 2409143 2022-04-15 Lawrence Indiana 18093 11853 259
2405887 2405887 2022-04-14 Lawrence Indiana 18093 11853 259
2402632 2402632 2022-04-13 Lawrence Indiana 18093 11853 259
2399377 2399377 2022-04-12 Lawrence Indiana 18093 11849 259
2396122 2396122 2022-04-11 Lawrence Indiana 18093 11849 259
2392866 2392866 2022-04-10 Lawrence Indiana 18093 11846 259
2389610 2389610 2022-04-09 Lawrence Indiana 18093 11846 259
2386355 2386355 2022-04-08 Lawrence Indiana 18093 11846 259
2383100 2383100 2022-04-07 Lawrence Indiana 18093 11846 259
2379845 2379845 2022-04-06 Lawrence Indiana 18093 11846 259
2376591 2376591 2022-04-05 Lawrence Indiana 18093 11843 259
2373339 2373339 2022-04-04 Lawrence Indiana 18093 11843 259
2370086 2370086 2022-04-03 Lawrence Indiana 18093 11840 259
2366833 2366833 2022-04-02 Lawrence Indiana 18093 11840 259
2363580 2363580 2022-04-01 Lawrence Indiana 18093 11840 259
2360326 2360326 2022-03-31 Lawrence Indiana 18093 11835 258
2357072 2357072 2022-03-30 Lawrence Indiana 18093 11835 258
2353819 2353819 2022-03-29 Lawrence Indiana 18093 11840 258
2350567 2350567 2022-03-28 Lawrence Indiana 18093 11840 258
2347314 2347314 2022-03-27 Lawrence Indiana 18093 11839 258
2344061 2344061 2022-03-26 Lawrence Indiana 18093 11839 258
2340808 2340808 2022-03-25 Lawrence Indiana 18093 11839 258
2337555 2337555 2022-03-24 Lawrence Indiana 18093 11835 258
2334301 2334301 2022-03-23 Lawrence Indiana 18093 11834 258
2331047 2331047 2022-03-22 Lawrence Indiana 18093 11832 258
2327795 2327795 2022-03-21 Lawrence Indiana 18093 11832 258
2324542 2324542 2022-03-20 Lawrence Indiana 18093 11824 258
2321288 2321288 2022-03-19 Lawrence Indiana 18093 11824 258
2318034 2318034 2022-03-18 Lawrence Indiana 18093 11824 258
2314781 2314781 2022-03-17 Lawrence Indiana 18093 11823 257
2311528 2311528 2022-03-16 Lawrence Indiana 18093 11820 257
2308275 2308275 2022-03-15 Lawrence Indiana 18093 11816 256
2305024 2305024 2022-03-14 Lawrence Indiana 18093 11816 256
2301772 2301772 2022-03-13 Lawrence Indiana 18093 11815 256
2298520 2298520 2022-03-12 Lawrence Indiana 18093 11815 256
2295268 2295268 2022-03-11 Lawrence Indiana 18093 11815 256
2292016 2292016 2022-03-10 Lawrence Indiana 18093 11812 255
2288764 2288764 2022-03-09 Lawrence Indiana 18093 11809 255
2285513 2285513 2022-03-08 Lawrence Indiana 18093 11807 253
2282261 2282261 2022-03-07 Lawrence Indiana 18093 11805 253
2279008 2279008 2022-03-06 Lawrence Indiana 18093 11801 253
2275755 2275755 2022-03-05 Lawrence Indiana 18093 11801 253
2272502 2272502 2022-03-04 Lawrence Indiana 18093 11801 253
2269250 2269250 2022-03-03 Lawrence Indiana 18093 11795 252
2265997 2265997 2022-03-02 Lawrence Indiana 18093 11791 252
2262746 2262746 2022-03-01 Lawrence Indiana 18093 11785 250
2259495 2259495 2022-02-28 Lawrence Indiana 18093 11779 250
2256244 2256244 2022-02-27 Lawrence Indiana 18093 11765 250
2252993 2252993 2022-02-26 Lawrence Indiana 18093 11765 250
2249742 2249742 2022-02-25 Lawrence Indiana 18093 11765 250
2246491 2246491 2022-02-24 Lawrence Indiana 18093 11762 246
2243240 2243240 2022-02-23 Lawrence Indiana 18093 11756 245
2239989 2239989 2022-02-22 Lawrence Indiana 18093 11753 244
2236738 2236738 2022-02-21 Lawrence Indiana 18093 11750 242
2233487 2233487 2022-02-20 Lawrence Indiana 18093 11737 242
2230236 2230236 2022-02-19 Lawrence Indiana 18093 11737 242
2226985 2226985 2022-02-18 Lawrence Indiana 18093 11737 242
2223734 2223734 2022-02-17 Lawrence Indiana 18093 11718 242
2220483 2220483 2022-02-16 Lawrence Indiana 18093 11709 242
2217232 2217232 2022-02-15 Lawrence Indiana 18093 11696 240
2213981 2213981 2022-02-14 Lawrence Indiana 18093 11686 239
2210729 2210729 2022-02-13 Lawrence Indiana 18093 11655 238
2207476 2207476 2022-02-12 Lawrence Indiana 18093 11655 238
2204223 2204223 2022-02-11 Lawrence Indiana 18093 11655 238
2200970 2200970 2022-02-10 Lawrence Indiana 18093 11624 237
2197716 2197716 2022-02-09 Lawrence Indiana 18093 11554 234
2194462 2194462 2022-02-08 Lawrence Indiana 18093 11554 234
2191208 2191208 2022-02-07 Lawrence Indiana 18093 11503 234
2187955 2187955 2022-02-06 Lawrence Indiana 18093 11452 232
2184702 2184702 2022-02-05 Lawrence Indiana 18093 11452 232
2181450 2181450 2022-02-04 Lawrence Indiana 18093 11452 232
2178199 2178199 2022-02-03 Lawrence Indiana 18093 11395 232

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