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

774 rows where county = "Lawrence" and state = "Kentucky" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Kentucky · 774 ✖

fips 1

county 1

  • Lawrence · 774 ✖
Link rowid date ▲ county state fips cases deaths
2500642 2500642 2022-05-13 Lawrence Kentucky 21127 4503 69
2497384 2497384 2022-05-12 Lawrence Kentucky 21127 4503 69
2494126 2494126 2022-05-11 Lawrence Kentucky 21127 4503 69
2490868 2490868 2022-05-10 Lawrence Kentucky 21127 4503 69
2487611 2487611 2022-05-09 Lawrence Kentucky 21127 4503 69
2484353 2484353 2022-05-08 Lawrence Kentucky 21127 4508 69
2481095 2481095 2022-05-07 Lawrence Kentucky 21127 4508 69
2477837 2477837 2022-05-06 Lawrence Kentucky 21127 4508 69
2474579 2474579 2022-05-05 Lawrence Kentucky 21127 4508 69
2471322 2471322 2022-05-04 Lawrence Kentucky 21127 4508 69
2468066 2468066 2022-05-03 Lawrence Kentucky 21127 4508 69
2464811 2464811 2022-05-02 Lawrence Kentucky 21127 4508 69
2461555 2461555 2022-05-01 Lawrence Kentucky 21127 4515 69
2458299 2458299 2022-04-30 Lawrence Kentucky 21127 4515 69
2455043 2455043 2022-04-29 Lawrence Kentucky 21127 4515 69
2451787 2451787 2022-04-28 Lawrence Kentucky 21127 4515 69
2448531 2448531 2022-04-27 Lawrence Kentucky 21127 4515 69
2445275 2445275 2022-04-26 Lawrence Kentucky 21127 4515 69
2442019 2442019 2022-04-25 Lawrence Kentucky 21127 4515 69
2438763 2438763 2022-04-24 Lawrence Kentucky 21127 4536 69
2435507 2435507 2022-04-23 Lawrence Kentucky 21127 4536 69
2432251 2432251 2022-04-22 Lawrence Kentucky 21127 4536 69
2428995 2428995 2022-04-21 Lawrence Kentucky 21127 4536 69
2425739 2425739 2022-04-20 Lawrence Kentucky 21127 4536 69
2422483 2422483 2022-04-19 Lawrence Kentucky 21127 4536 69
2419227 2419227 2022-04-18 Lawrence Kentucky 21127 4536 69
2415971 2415971 2022-04-17 Lawrence Kentucky 21127 4550 68
2412715 2412715 2022-04-16 Lawrence Kentucky 21127 4550 68
2409459 2409459 2022-04-15 Lawrence Kentucky 21127 4550 68
2406203 2406203 2022-04-14 Lawrence Kentucky 21127 4550 68
2402947 2402947 2022-04-13 Lawrence Kentucky 21127 4550 68
2399693 2399693 2022-04-12 Lawrence Kentucky 21127 4550 68
2396437 2396437 2022-04-11 Lawrence Kentucky 21127 4550 68
2393182 2393182 2022-04-10 Lawrence Kentucky 21127 4548 67
2389926 2389926 2022-04-09 Lawrence Kentucky 21127 4548 67
2386670 2386670 2022-04-08 Lawrence Kentucky 21127 4548 67
2383415 2383415 2022-04-07 Lawrence Kentucky 21127 4548 67
2380160 2380160 2022-04-06 Lawrence Kentucky 21127 4548 67
2376905 2376905 2022-04-05 Lawrence Kentucky 21127 4548 67
2373653 2373653 2022-04-04 Lawrence Kentucky 21127 4548 67
2370400 2370400 2022-04-03 Lawrence Kentucky 21127 4544 67
2367147 2367147 2022-04-02 Lawrence Kentucky 21127 4544 67
2363894 2363894 2022-04-01 Lawrence Kentucky 21127 4544 67
2360640 2360640 2022-03-31 Lawrence Kentucky 21127 4544 67
2357386 2357386 2022-03-30 Lawrence Kentucky 21127 4544 67
2354133 2354133 2022-03-29 Lawrence Kentucky 21127 4544 67
2350881 2350881 2022-03-28 Lawrence Kentucky 21127 4544 67
2347628 2347628 2022-03-27 Lawrence Kentucky 21127 4539 67
2344375 2344375 2022-03-26 Lawrence Kentucky 21127 4539 67
2341122 2341122 2022-03-25 Lawrence Kentucky 21127 4539 67
2337869 2337869 2022-03-24 Lawrence Kentucky 21127 4539 67
2334615 2334615 2022-03-23 Lawrence Kentucky 21127 4539 67
2331361 2331361 2022-03-22 Lawrence Kentucky 21127 4539 67
2328109 2328109 2022-03-21 Lawrence Kentucky 21127 4539 67
2324856 2324856 2022-03-20 Lawrence Kentucky 21127 4520 63
2321602 2321602 2022-03-19 Lawrence Kentucky 21127 4520 63
2318348 2318348 2022-03-18 Lawrence Kentucky 21127 4520 63
2315095 2315095 2022-03-17 Lawrence Kentucky 21127 4520 63
2311842 2311842 2022-03-16 Lawrence Kentucky 21127 4520 63
2308589 2308589 2022-03-15 Lawrence Kentucky 21127 4520 63
2305338 2305338 2022-03-14 Lawrence Kentucky 21127 4520 63
2302086 2302086 2022-03-13 Lawrence Kentucky 21127 4485 59
2298834 2298834 2022-03-12 Lawrence Kentucky 21127 4485 59
2295582 2295582 2022-03-11 Lawrence Kentucky 21127 4485 59
2292330 2292330 2022-03-10 Lawrence Kentucky 21127 4485 59
2289078 2289078 2022-03-09 Lawrence Kentucky 21127 4485 59
2285827 2285827 2022-03-08 Lawrence Kentucky 21127 4485 59
2282575 2282575 2022-03-07 Lawrence Kentucky 21127 4485 59
2279322 2279322 2022-03-06 Lawrence Kentucky 21127 4475 59
2276069 2276069 2022-03-05 Lawrence Kentucky 21127 4475 59
2272816 2272816 2022-03-04 Lawrence Kentucky 21127 4475 59
2269564 2269564 2022-03-03 Lawrence Kentucky 21127 4473 59
2266311 2266311 2022-03-02 Lawrence Kentucky 21127 4469 59
2263060 2263060 2022-03-01 Lawrence Kentucky 21127 4450 59
2259809 2259809 2022-02-28 Lawrence Kentucky 21127 4433 59
2256558 2256558 2022-02-27 Lawrence Kentucky 21127 4408 59
2253307 2253307 2022-02-26 Lawrence Kentucky 21127 4408 59
2250056 2250056 2022-02-25 Lawrence Kentucky 21127 4408 59
2246805 2246805 2022-02-24 Lawrence Kentucky 21127 4381 59
2243554 2243554 2022-02-23 Lawrence Kentucky 21127 4381 59
2240303 2240303 2022-02-22 Lawrence Kentucky 21127 4368 59
2237052 2237052 2022-02-21 Lawrence Kentucky 21127 4337 59
2233801 2233801 2022-02-20 Lawrence Kentucky 21127 4306 58
2230550 2230550 2022-02-19 Lawrence Kentucky 21127 4306 58
2227299 2227299 2022-02-18 Lawrence Kentucky 21127 4306 58
2224048 2224048 2022-02-17 Lawrence Kentucky 21127 4288 57
2220797 2220797 2022-02-16 Lawrence Kentucky 21127 4269 56
2217546 2217546 2022-02-15 Lawrence Kentucky 21127 4242 56
2214295 2214295 2022-02-14 Lawrence Kentucky 21127 4219 56
2211043 2211043 2022-02-13 Lawrence Kentucky 21127 4168 56
2207790 2207790 2022-02-12 Lawrence Kentucky 21127 4168 56
2204537 2204537 2022-02-11 Lawrence Kentucky 21127 4168 56
2201284 2201284 2022-02-10 Lawrence Kentucky 21127 4135 56
2198030 2198030 2022-02-09 Lawrence Kentucky 21127 4107 55
2194776 2194776 2022-02-08 Lawrence Kentucky 21127 4084 54
2191522 2191522 2022-02-07 Lawrence Kentucky 21127 4054 54
2188269 2188269 2022-02-06 Lawrence Kentucky 21127 4011 53
2185016 2185016 2022-02-05 Lawrence Kentucky 21127 4011 53
2181764 2181764 2022-02-04 Lawrence Kentucky 21127 4011 53
2178513 2178513 2022-02-03 Lawrence Kentucky 21127 3986 53

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