home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

786 rows where county = "Pulaski" 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 · 786 ✖

fips 1

  • 21199 786

county 1

  • Pulaski · 786 ✖
Link rowid date ▲ county state fips cases deaths
2500678 2500678 2022-05-13 Pulaski Kentucky 21199 18157 293
2497420 2497420 2022-05-12 Pulaski Kentucky 21199 18157 293
2494162 2494162 2022-05-11 Pulaski Kentucky 21199 18157 293
2490904 2490904 2022-05-10 Pulaski Kentucky 21199 18157 293
2487647 2487647 2022-05-09 Pulaski Kentucky 21199 18157 293
2484389 2484389 2022-05-08 Pulaski Kentucky 21199 18132 285
2481131 2481131 2022-05-07 Pulaski Kentucky 21199 18132 285
2477873 2477873 2022-05-06 Pulaski Kentucky 21199 18132 285
2474615 2474615 2022-05-05 Pulaski Kentucky 21199 18132 285
2471358 2471358 2022-05-04 Pulaski Kentucky 21199 18132 285
2468102 2468102 2022-05-03 Pulaski Kentucky 21199 18132 285
2464847 2464847 2022-05-02 Pulaski Kentucky 21199 18132 285
2461591 2461591 2022-05-01 Pulaski Kentucky 21199 18107 282
2458335 2458335 2022-04-30 Pulaski Kentucky 21199 18107 282
2455079 2455079 2022-04-29 Pulaski Kentucky 21199 18107 282
2451823 2451823 2022-04-28 Pulaski Kentucky 21199 18107 282
2448567 2448567 2022-04-27 Pulaski Kentucky 21199 18107 282
2445311 2445311 2022-04-26 Pulaski Kentucky 21199 18107 282
2442055 2442055 2022-04-25 Pulaski Kentucky 21199 18107 282
2438799 2438799 2022-04-24 Pulaski Kentucky 21199 18090 280
2435543 2435543 2022-04-23 Pulaski Kentucky 21199 18090 280
2432287 2432287 2022-04-22 Pulaski Kentucky 21199 18090 280
2429031 2429031 2022-04-21 Pulaski Kentucky 21199 18090 280
2425775 2425775 2022-04-20 Pulaski Kentucky 21199 18090 280
2422519 2422519 2022-04-19 Pulaski Kentucky 21199 18090 280
2419263 2419263 2022-04-18 Pulaski Kentucky 21199 18090 280
2416007 2416007 2022-04-17 Pulaski Kentucky 21199 18078 279
2412751 2412751 2022-04-16 Pulaski Kentucky 21199 18078 279
2409495 2409495 2022-04-15 Pulaski Kentucky 21199 18078 279
2406239 2406239 2022-04-14 Pulaski Kentucky 21199 18078 279
2402983 2402983 2022-04-13 Pulaski Kentucky 21199 18078 279
2399729 2399729 2022-04-12 Pulaski Kentucky 21199 18078 279
2396473 2396473 2022-04-11 Pulaski Kentucky 21199 18078 279
2393218 2393218 2022-04-10 Pulaski Kentucky 21199 18051 274
2389962 2389962 2022-04-09 Pulaski Kentucky 21199 18051 274
2386706 2386706 2022-04-08 Pulaski Kentucky 21199 18051 274
2383451 2383451 2022-04-07 Pulaski Kentucky 21199 18051 274
2380196 2380196 2022-04-06 Pulaski Kentucky 21199 18051 274
2376941 2376941 2022-04-05 Pulaski Kentucky 21199 18051 274
2373689 2373689 2022-04-04 Pulaski Kentucky 21199 18051 274
2370436 2370436 2022-04-03 Pulaski Kentucky 21199 17848 274
2367183 2367183 2022-04-02 Pulaski Kentucky 21199 17848 274
2363930 2363930 2022-04-01 Pulaski Kentucky 21199 17848 274
2360676 2360676 2022-03-31 Pulaski Kentucky 21199 17848 274
2357422 2357422 2022-03-30 Pulaski Kentucky 21199 17848 274
2354169 2354169 2022-03-29 Pulaski Kentucky 21199 17848 274
2350917 2350917 2022-03-28 Pulaski Kentucky 21199 17848 274
2347664 2347664 2022-03-27 Pulaski Kentucky 21199 17375 269
2344411 2344411 2022-03-26 Pulaski Kentucky 21199 17375 269
2341158 2341158 2022-03-25 Pulaski Kentucky 21199 17375 269
2337905 2337905 2022-03-24 Pulaski Kentucky 21199 17375 269
2334651 2334651 2022-03-23 Pulaski Kentucky 21199 17375 269
2331397 2331397 2022-03-22 Pulaski Kentucky 21199 17375 269
2328145 2328145 2022-03-21 Pulaski Kentucky 21199 17375 269
2324892 2324892 2022-03-20 Pulaski Kentucky 21199 16907 264
2321638 2321638 2022-03-19 Pulaski Kentucky 21199 16907 264
2318384 2318384 2022-03-18 Pulaski Kentucky 21199 16907 264
2315131 2315131 2022-03-17 Pulaski Kentucky 21199 16907 264
2311878 2311878 2022-03-16 Pulaski Kentucky 21199 16907 264
2308625 2308625 2022-03-15 Pulaski Kentucky 21199 16907 264
2305374 2305374 2022-03-14 Pulaski Kentucky 21199 16907 264
2302122 2302122 2022-03-13 Pulaski Kentucky 21199 16088 256
2298870 2298870 2022-03-12 Pulaski Kentucky 21199 16088 256
2295618 2295618 2022-03-11 Pulaski Kentucky 21199 16088 256
2292366 2292366 2022-03-10 Pulaski Kentucky 21199 16088 256
2289114 2289114 2022-03-09 Pulaski Kentucky 21199 16088 256
2285863 2285863 2022-03-08 Pulaski Kentucky 21199 16088 256
2282611 2282611 2022-03-07 Pulaski Kentucky 21199 16088 256
2279358 2279358 2022-03-06 Pulaski Kentucky 21199 15991 254
2276105 2276105 2022-03-05 Pulaski Kentucky 21199 15991 254
2272852 2272852 2022-03-04 Pulaski Kentucky 21199 15991 254
2269600 2269600 2022-03-03 Pulaski Kentucky 21199 15903 253
2266347 2266347 2022-03-02 Pulaski Kentucky 21199 15851 253
2263096 2263096 2022-03-01 Pulaski Kentucky 21199 15766 253
2259845 2259845 2022-02-28 Pulaski Kentucky 21199 15665 253
2256594 2256594 2022-02-27 Pulaski Kentucky 21199 15596 253
2253343 2253343 2022-02-26 Pulaski Kentucky 21199 15596 253
2250092 2250092 2022-02-25 Pulaski Kentucky 21199 15596 253
2246841 2246841 2022-02-24 Pulaski Kentucky 21199 15493 253
2243590 2243590 2022-02-23 Pulaski Kentucky 21199 15493 253
2240339 2240339 2022-02-22 Pulaski Kentucky 21199 15449 252
2237088 2237088 2022-02-21 Pulaski Kentucky 21199 15382 252
2233837 2233837 2022-02-20 Pulaski Kentucky 21199 15281 252
2230586 2230586 2022-02-19 Pulaski Kentucky 21199 15281 252
2227335 2227335 2022-02-18 Pulaski Kentucky 21199 15281 252
2224084 2224084 2022-02-17 Pulaski Kentucky 21199 15194 252
2220833 2220833 2022-02-16 Pulaski Kentucky 21199 15093 252
2217582 2217582 2022-02-15 Pulaski Kentucky 21199 15038 252
2214331 2214331 2022-02-14 Pulaski Kentucky 21199 14995 251
2211079 2211079 2022-02-13 Pulaski Kentucky 21199 14804 251
2207826 2207826 2022-02-12 Pulaski Kentucky 21199 14804 251
2204573 2204573 2022-02-11 Pulaski Kentucky 21199 14804 251
2201320 2201320 2022-02-10 Pulaski Kentucky 21199 14764 251
2198066 2198066 2022-02-09 Pulaski Kentucky 21199 14726 248
2194812 2194812 2022-02-08 Pulaski Kentucky 21199 14681 248
2191558 2191558 2022-02-07 Pulaski Kentucky 21199 14611 248
2188305 2188305 2022-02-06 Pulaski Kentucky 21199 14465 244
2185052 2185052 2022-02-05 Pulaski Kentucky 21199 14465 244
2181800 2181800 2022-02-04 Pulaski Kentucky 21199 14465 244
2178549 2178549 2022-02-03 Pulaski Kentucky 21199 14385 244

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);
Powered by Datasette · Queries took 443.869ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette