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

787 rows where county = "Jennings" 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 · 787 ✖

fips 1

  • 18079 787

county 1

  • Jennings · 787 ✖
Link rowid date ▲ county state fips cases deaths
2500319 2500319 2022-05-13 Jennings Indiana 18079 6995 108
2497061 2497061 2022-05-12 Jennings Indiana 18079 6990 108
2493803 2493803 2022-05-11 Jennings Indiana 18079 6990 108
2490545 2490545 2022-05-10 Jennings Indiana 18079 6987 108
2487288 2487288 2022-05-09 Jennings Indiana 18079 6987 108
2484030 2484030 2022-05-08 Jennings Indiana 18079 6974 108
2480772 2480772 2022-05-07 Jennings Indiana 18079 6974 108
2477514 2477514 2022-05-06 Jennings Indiana 18079 6974 108
2474256 2474256 2022-05-05 Jennings Indiana 18079 6974 108
2470999 2470999 2022-05-04 Jennings Indiana 18079 6974 108
2467743 2467743 2022-05-03 Jennings Indiana 18079 6954 108
2464488 2464488 2022-05-02 Jennings Indiana 18079 6954 108
2461232 2461232 2022-05-01 Jennings Indiana 18079 6953 108
2457976 2457976 2022-04-30 Jennings Indiana 18079 6953 108
2454720 2454720 2022-04-29 Jennings Indiana 18079 6953 108
2451464 2451464 2022-04-28 Jennings Indiana 18079 6944 108
2448208 2448208 2022-04-27 Jennings Indiana 18079 6944 108
2444952 2444952 2022-04-26 Jennings Indiana 18079 6944 108
2441696 2441696 2022-04-25 Jennings Indiana 18079 6944 108
2438440 2438440 2022-04-24 Jennings Indiana 18079 6938 108
2435184 2435184 2022-04-23 Jennings Indiana 18079 6938 108
2431928 2431928 2022-04-22 Jennings Indiana 18079 6938 108
2428672 2428672 2022-04-21 Jennings Indiana 18079 6936 108
2425416 2425416 2022-04-20 Jennings Indiana 18079 6936 108
2422160 2422160 2022-04-19 Jennings Indiana 18079 6936 108
2418904 2418904 2022-04-18 Jennings Indiana 18079 6936 108
2415648 2415648 2022-04-17 Jennings Indiana 18079 6935 108
2412392 2412392 2022-04-16 Jennings Indiana 18079 6935 108
2409136 2409136 2022-04-15 Jennings Indiana 18079 6935 108
2405880 2405880 2022-04-14 Jennings Indiana 18079 6935 108
2402625 2402625 2022-04-13 Jennings Indiana 18079 6935 108
2399370 2399370 2022-04-12 Jennings Indiana 18079 6935 108
2396115 2396115 2022-04-11 Jennings Indiana 18079 6935 108
2392859 2392859 2022-04-10 Jennings Indiana 18079 6936 108
2389603 2389603 2022-04-09 Jennings Indiana 18079 6936 108
2386348 2386348 2022-04-08 Jennings Indiana 18079 6936 108
2383093 2383093 2022-04-07 Jennings Indiana 18079 6935 108
2379838 2379838 2022-04-06 Jennings Indiana 18079 6935 108
2376584 2376584 2022-04-05 Jennings Indiana 18079 6935 108
2373332 2373332 2022-04-04 Jennings Indiana 18079 6935 108
2370079 2370079 2022-04-03 Jennings Indiana 18079 6936 108
2366826 2366826 2022-04-02 Jennings Indiana 18079 6936 108
2363573 2363573 2022-04-01 Jennings Indiana 18079 6936 108
2360319 2360319 2022-03-31 Jennings Indiana 18079 6935 108
2357065 2357065 2022-03-30 Jennings Indiana 18079 6935 108
2353812 2353812 2022-03-29 Jennings Indiana 18079 6946 108
2350560 2350560 2022-03-28 Jennings Indiana 18079 6946 108
2347307 2347307 2022-03-27 Jennings Indiana 18079 6945 108
2344054 2344054 2022-03-26 Jennings Indiana 18079 6945 108
2340801 2340801 2022-03-25 Jennings Indiana 18079 6945 108
2337548 2337548 2022-03-24 Jennings Indiana 18079 6945 107
2334294 2334294 2022-03-23 Jennings Indiana 18079 6945 107
2331040 2331040 2022-03-22 Jennings Indiana 18079 6944 107
2327788 2327788 2022-03-21 Jennings Indiana 18079 6943 107
2324535 2324535 2022-03-20 Jennings Indiana 18079 6942 107
2321281 2321281 2022-03-19 Jennings Indiana 18079 6942 107
2318027 2318027 2022-03-18 Jennings Indiana 18079 6942 107
2314774 2314774 2022-03-17 Jennings Indiana 18079 6942 107
2311521 2311521 2022-03-16 Jennings Indiana 18079 6941 107
2308268 2308268 2022-03-15 Jennings Indiana 18079 6939 106
2305017 2305017 2022-03-14 Jennings Indiana 18079 6939 106
2301765 2301765 2022-03-13 Jennings Indiana 18079 6939 105
2298513 2298513 2022-03-12 Jennings Indiana 18079 6939 105
2295261 2295261 2022-03-11 Jennings Indiana 18079 6939 105
2292009 2292009 2022-03-10 Jennings Indiana 18079 6939 104
2288757 2288757 2022-03-09 Jennings Indiana 18079 6936 104
2285506 2285506 2022-03-08 Jennings Indiana 18079 6936 103
2282254 2282254 2022-03-07 Jennings Indiana 18079 6936 103
2279001 2279001 2022-03-06 Jennings Indiana 18079 6933 103
2275748 2275748 2022-03-05 Jennings Indiana 18079 6933 103
2272495 2272495 2022-03-04 Jennings Indiana 18079 6933 103
2269243 2269243 2022-03-03 Jennings Indiana 18079 6928 103
2265990 2265990 2022-03-02 Jennings Indiana 18079 6928 103
2262739 2262739 2022-03-01 Jennings Indiana 18079 6925 103
2259488 2259488 2022-02-28 Jennings Indiana 18079 6924 103
2256237 2256237 2022-02-27 Jennings Indiana 18079 6912 103
2252986 2252986 2022-02-26 Jennings Indiana 18079 6912 103
2249735 2249735 2022-02-25 Jennings Indiana 18079 6912 103
2246484 2246484 2022-02-24 Jennings Indiana 18079 6909 103
2243233 2243233 2022-02-23 Jennings Indiana 18079 6907 103
2239982 2239982 2022-02-22 Jennings Indiana 18079 6902 103
2236731 2236731 2022-02-21 Jennings Indiana 18079 6899 102
2233480 2233480 2022-02-20 Jennings Indiana 18079 6891 102
2230229 2230229 2022-02-19 Jennings Indiana 18079 6891 102
2226978 2226978 2022-02-18 Jennings Indiana 18079 6891 102
2223727 2223727 2022-02-17 Jennings Indiana 18079 6883 101
2220476 2220476 2022-02-16 Jennings Indiana 18079 6881 101
2217225 2217225 2022-02-15 Jennings Indiana 18079 6865 99
2213974 2213974 2022-02-14 Jennings Indiana 18079 6856 99
2210722 2210722 2022-02-13 Jennings Indiana 18079 6837 99
2207469 2207469 2022-02-12 Jennings Indiana 18079 6837 99
2204216 2204216 2022-02-11 Jennings Indiana 18079 6837 99
2200963 2200963 2022-02-10 Jennings Indiana 18079 6819 99
2197709 2197709 2022-02-09 Jennings Indiana 18079 6781 97
2194455 2194455 2022-02-08 Jennings Indiana 18079 6781 97
2191201 2191201 2022-02-07 Jennings Indiana 18079 6760 96
2187948 2187948 2022-02-06 Jennings Indiana 18079 6731 96
2184695 2184695 2022-02-05 Jennings Indiana 18079 6731 96
2181443 2181443 2022-02-04 Jennings Indiana 18079 6731 96
2178192 2178192 2022-02-03 Jennings Indiana 18079 6712 96

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 197.115ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette