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

799 rows where county = "Marion" and fips = 18097 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Indiana 799

fips 1

  • 18097 · 799 ✖

county 1

  • Marion · 799 ✖
Link rowid date ▲ county state fips cases deaths
2500328 2500328 2022-05-13 Marion Indiana 18097 227486 3000
2497070 2497070 2022-05-12 Marion Indiana 18097 227159 3000
2493812 2493812 2022-05-11 Marion Indiana 18097 227159 3000
2490554 2490554 2022-05-10 Marion Indiana 18097 227007 3000
2487297 2487297 2022-05-09 Marion Indiana 18097 227007 3000
2484039 2484039 2022-05-08 Marion Indiana 18097 226560 2995
2480781 2480781 2022-05-07 Marion Indiana 18097 226560 2995
2477523 2477523 2022-05-06 Marion Indiana 18097 226560 2995
2474265 2474265 2022-05-05 Marion Indiana 18097 226560 2995
2471008 2471008 2022-05-04 Marion Indiana 18097 226560 2995
2467752 2467752 2022-05-03 Marion Indiana 18097 226324 2995
2464497 2464497 2022-05-02 Marion Indiana 18097 226324 2995
2461241 2461241 2022-05-01 Marion Indiana 18097 226157 2995
2457985 2457985 2022-04-30 Marion Indiana 18097 226157 2995
2454729 2454729 2022-04-29 Marion Indiana 18097 226157 2995
2451473 2451473 2022-04-28 Marion Indiana 18097 225983 2991
2448217 2448217 2022-04-27 Marion Indiana 18097 225983 2991
2444961 2444961 2022-04-26 Marion Indiana 18097 225832 2991
2441705 2441705 2022-04-25 Marion Indiana 18097 225832 2991
2438449 2438449 2022-04-24 Marion Indiana 18097 225372 2991
2435193 2435193 2022-04-23 Marion Indiana 18097 225372 2991
2431937 2431937 2022-04-22 Marion Indiana 18097 225372 2991
2428681 2428681 2022-04-21 Marion Indiana 18097 225269 2991
2425425 2425425 2022-04-20 Marion Indiana 18097 225269 2991
2422169 2422169 2022-04-19 Marion Indiana 18097 225177 2990
2418913 2418913 2022-04-18 Marion Indiana 18097 225177 2990
2415657 2415657 2022-04-17 Marion Indiana 18097 225013 2990
2412401 2412401 2022-04-16 Marion Indiana 18097 225013 2990
2409145 2409145 2022-04-15 Marion Indiana 18097 225013 2990
2405889 2405889 2022-04-14 Marion Indiana 18097 225013 2990
2402634 2402634 2022-04-13 Marion Indiana 18097 225013 2990
2399379 2399379 2022-04-12 Marion Indiana 18097 224954 2987
2396124 2396124 2022-04-11 Marion Indiana 18097 224954 2987
2392868 2392868 2022-04-10 Marion Indiana 18097 224913 2985
2389612 2389612 2022-04-09 Marion Indiana 18097 224913 2985
2386357 2386357 2022-04-08 Marion Indiana 18097 224913 2985
2383102 2383102 2022-04-07 Marion Indiana 18097 224862 2982
2379847 2379847 2022-04-06 Marion Indiana 18097 224862 2982
2376593 2376593 2022-04-05 Marion Indiana 18097 224820 2979
2373341 2373341 2022-04-04 Marion Indiana 18097 224820 2979
2370088 2370088 2022-04-03 Marion Indiana 18097 224788 2978
2366835 2366835 2022-04-02 Marion Indiana 18097 224788 2978
2363582 2363582 2022-04-01 Marion Indiana 18097 224788 2978
2360328 2360328 2022-03-31 Marion Indiana 18097 224707 2966
2357074 2357074 2022-03-30 Marion Indiana 18097 224707 2966
2353821 2353821 2022-03-29 Marion Indiana 18097 224957 2966
2350569 2350569 2022-03-28 Marion Indiana 18097 224934 2965
2347316 2347316 2022-03-27 Marion Indiana 18097 224868 2965
2344063 2344063 2022-03-26 Marion Indiana 18097 224868 2965
2340810 2340810 2022-03-25 Marion Indiana 18097 224868 2965
2337557 2337557 2022-03-24 Marion Indiana 18097 224841 2962
2334303 2334303 2022-03-23 Marion Indiana 18097 224808 2962
2331049 2331049 2022-03-22 Marion Indiana 18097 224777 2956
2327797 2327797 2022-03-21 Marion Indiana 18097 224800 2956
2324544 2324544 2022-03-20 Marion Indiana 18097 224810 2955
2321290 2321290 2022-03-19 Marion Indiana 18097 224810 2955
2318036 2318036 2022-03-18 Marion Indiana 18097 224810 2955
2314783 2314783 2022-03-17 Marion Indiana 18097 224552 2949
2311530 2311530 2022-03-16 Marion Indiana 18097 224522 2946
2308277 2308277 2022-03-15 Marion Indiana 18097 224492 2941
2305026 2305026 2022-03-14 Marion Indiana 18097 224463 2940
2301774 2301774 2022-03-13 Marion Indiana 18097 224393 2939
2298522 2298522 2022-03-12 Marion Indiana 18097 224393 2939
2295270 2295270 2022-03-11 Marion Indiana 18097 224393 2939
2292018 2292018 2022-03-10 Marion Indiana 18097 224368 2938
2288766 2288766 2022-03-09 Marion Indiana 18097 224325 2937
2285515 2285515 2022-03-08 Marion Indiana 18097 224277 2927
2282263 2282263 2022-03-07 Marion Indiana 18097 224236 2926
2279010 2279010 2022-03-06 Marion Indiana 18097 223657 2926
2275757 2275757 2022-03-05 Marion Indiana 18097 223657 2926
2272504 2272504 2022-03-04 Marion Indiana 18097 223657 2926
2269252 2269252 2022-03-03 Marion Indiana 18097 223606 2923
2265999 2265999 2022-03-02 Marion Indiana 18097 223566 2923
2262748 2262748 2022-03-01 Marion Indiana 18097 223524 2915
2259497 2259497 2022-02-28 Marion Indiana 18097 223482 2911
2256246 2256246 2022-02-27 Marion Indiana 18097 223355 2904
2252995 2252995 2022-02-26 Marion Indiana 18097 223355 2904
2249744 2249744 2022-02-25 Marion Indiana 18097 223355 2904
2246493 2246493 2022-02-24 Marion Indiana 18097 223288 2897
2243242 2243242 2022-02-23 Marion Indiana 18097 223174 2896
2239991 2239991 2022-02-22 Marion Indiana 18097 223093 2889
2236740 2236740 2022-02-21 Marion Indiana 18097 223018 2883
2233489 2233489 2022-02-20 Marion Indiana 18097 222743 2878
2230238 2230238 2022-02-19 Marion Indiana 18097 222743 2878
2226987 2226987 2022-02-18 Marion Indiana 18097 222743 2878
2223736 2223736 2022-02-17 Marion Indiana 18097 222618 2864
2220485 2220485 2022-02-16 Marion Indiana 18097 222516 2863
2217234 2217234 2022-02-15 Marion Indiana 18097 222403 2852
2213983 2213983 2022-02-14 Marion Indiana 18097 222288 2844
2210731 2210731 2022-02-13 Marion Indiana 18097 221881 2837
2207478 2207478 2022-02-12 Marion Indiana 18097 221881 2837
2204225 2204225 2022-02-11 Marion Indiana 18097 221881 2837
2200972 2200972 2022-02-10 Marion Indiana 18097 221609 2825
2197718 2197718 2022-02-09 Marion Indiana 18097 221099 2811
2194464 2194464 2022-02-08 Marion Indiana 18097 221099 2811
2191210 2191210 2022-02-07 Marion Indiana 18097 220797 2799
2187957 2187957 2022-02-06 Marion Indiana 18097 220207 2788
2184704 2184704 2022-02-05 Marion Indiana 18097 220207 2788
2181452 2181452 2022-02-04 Marion Indiana 18097 220207 2788
2178201 2178201 2022-02-03 Marion Indiana 18097 219817 2781

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