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

776 rows where county = "Greene" 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 · 776 ✖

fips 1

county 1

  • Greene · 776 ✖
Link rowid date ▲ county state fips cases deaths
2500307 2500307 2022-05-13 Greene Indiana 18055 7262 139
2497049 2497049 2022-05-12 Greene Indiana 18055 7252 139
2493791 2493791 2022-05-11 Greene Indiana 18055 7252 139
2490533 2490533 2022-05-10 Greene Indiana 18055 7245 139
2487276 2487276 2022-05-09 Greene Indiana 18055 7245 139
2484018 2484018 2022-05-08 Greene Indiana 18055 7236 139
2480760 2480760 2022-05-07 Greene Indiana 18055 7236 139
2477502 2477502 2022-05-06 Greene Indiana 18055 7236 139
2474244 2474244 2022-05-05 Greene Indiana 18055 7236 139
2470987 2470987 2022-05-04 Greene Indiana 18055 7236 139
2467731 2467731 2022-05-03 Greene Indiana 18055 7231 139
2464476 2464476 2022-05-02 Greene Indiana 18055 7231 139
2461220 2461220 2022-05-01 Greene Indiana 18055 7230 139
2457964 2457964 2022-04-30 Greene Indiana 18055 7230 139
2454708 2454708 2022-04-29 Greene Indiana 18055 7230 139
2451452 2451452 2022-04-28 Greene Indiana 18055 7225 139
2448196 2448196 2022-04-27 Greene Indiana 18055 7225 139
2444940 2444940 2022-04-26 Greene Indiana 18055 7220 139
2441684 2441684 2022-04-25 Greene Indiana 18055 7220 139
2438428 2438428 2022-04-24 Greene Indiana 18055 7211 139
2435172 2435172 2022-04-23 Greene Indiana 18055 7211 139
2431916 2431916 2022-04-22 Greene Indiana 18055 7211 139
2428660 2428660 2022-04-21 Greene Indiana 18055 7208 139
2425404 2425404 2022-04-20 Greene Indiana 18055 7208 139
2422148 2422148 2022-04-19 Greene Indiana 18055 7203 139
2418892 2418892 2022-04-18 Greene Indiana 18055 7203 139
2415636 2415636 2022-04-17 Greene Indiana 18055 7199 139
2412380 2412380 2022-04-16 Greene Indiana 18055 7199 139
2409124 2409124 2022-04-15 Greene Indiana 18055 7199 139
2405868 2405868 2022-04-14 Greene Indiana 18055 7199 139
2402613 2402613 2022-04-13 Greene Indiana 18055 7199 139
2399358 2399358 2022-04-12 Greene Indiana 18055 7199 139
2396103 2396103 2022-04-11 Greene Indiana 18055 7199 139
2392847 2392847 2022-04-10 Greene Indiana 18055 7199 139
2389591 2389591 2022-04-09 Greene Indiana 18055 7199 139
2386336 2386336 2022-04-08 Greene Indiana 18055 7199 139
2383081 2383081 2022-04-07 Greene Indiana 18055 7195 139
2379826 2379826 2022-04-06 Greene Indiana 18055 7195 139
2376572 2376572 2022-04-05 Greene Indiana 18055 7193 139
2373320 2373320 2022-04-04 Greene Indiana 18055 7193 139
2370067 2370067 2022-04-03 Greene Indiana 18055 7193 139
2366814 2366814 2022-04-02 Greene Indiana 18055 7193 139
2363561 2363561 2022-04-01 Greene Indiana 18055 7193 139
2360307 2360307 2022-03-31 Greene Indiana 18055 7192 139
2357053 2357053 2022-03-30 Greene Indiana 18055 7192 139
2353800 2353800 2022-03-29 Greene Indiana 18055 7205 139
2350548 2350548 2022-03-28 Greene Indiana 18055 7204 139
2347295 2347295 2022-03-27 Greene Indiana 18055 7202 139
2344042 2344042 2022-03-26 Greene Indiana 18055 7202 139
2340789 2340789 2022-03-25 Greene Indiana 18055 7202 139
2337536 2337536 2022-03-24 Greene Indiana 18055 7201 139
2334282 2334282 2022-03-23 Greene Indiana 18055 7200 139
2331028 2331028 2022-03-22 Greene Indiana 18055 7198 138
2327776 2327776 2022-03-21 Greene Indiana 18055 7197 138
2324523 2324523 2022-03-20 Greene Indiana 18055 7197 138
2321269 2321269 2022-03-19 Greene Indiana 18055 7197 138
2318015 2318015 2022-03-18 Greene Indiana 18055 7197 138
2314762 2314762 2022-03-17 Greene Indiana 18055 7195 138
2311509 2311509 2022-03-16 Greene Indiana 18055 7192 138
2308256 2308256 2022-03-15 Greene Indiana 18055 7192 138
2305005 2305005 2022-03-14 Greene Indiana 18055 7190 138
2301753 2301753 2022-03-13 Greene Indiana 18055 7186 138
2298501 2298501 2022-03-12 Greene Indiana 18055 7186 138
2295249 2295249 2022-03-11 Greene Indiana 18055 7186 138
2291997 2291997 2022-03-10 Greene Indiana 18055 7183 138
2288745 2288745 2022-03-09 Greene Indiana 18055 7183 138
2285494 2285494 2022-03-08 Greene Indiana 18055 7180 137
2282242 2282242 2022-03-07 Greene Indiana 18055 7175 137
2278989 2278989 2022-03-06 Greene Indiana 18055 7173 137
2275736 2275736 2022-03-05 Greene Indiana 18055 7173 137
2272483 2272483 2022-03-04 Greene Indiana 18055 7173 137
2269231 2269231 2022-03-03 Greene Indiana 18055 7173 137
2265978 2265978 2022-03-02 Greene Indiana 18055 7169 137
2262727 2262727 2022-03-01 Greene Indiana 18055 7166 137
2259476 2259476 2022-02-28 Greene Indiana 18055 7159 136
2256225 2256225 2022-02-27 Greene Indiana 18055 7154 135
2252974 2252974 2022-02-26 Greene Indiana 18055 7154 135
2249723 2249723 2022-02-25 Greene Indiana 18055 7154 135
2246472 2246472 2022-02-24 Greene Indiana 18055 7153 135
2243221 2243221 2022-02-23 Greene Indiana 18055 7151 135
2239970 2239970 2022-02-22 Greene Indiana 18055 7148 135
2236719 2236719 2022-02-21 Greene Indiana 18055 7143 134
2233468 2233468 2022-02-20 Greene Indiana 18055 7130 133
2230217 2230217 2022-02-19 Greene Indiana 18055 7130 133
2226966 2226966 2022-02-18 Greene Indiana 18055 7130 133
2223715 2223715 2022-02-17 Greene Indiana 18055 7115 131
2220464 2220464 2022-02-16 Greene Indiana 18055 7102 131
2217213 2217213 2022-02-15 Greene Indiana 18055 7088 130
2213962 2213962 2022-02-14 Greene Indiana 18055 7072 130
2210710 2210710 2022-02-13 Greene Indiana 18055 7021 130
2207457 2207457 2022-02-12 Greene Indiana 18055 7021 130
2204204 2204204 2022-02-11 Greene Indiana 18055 7021 130
2200951 2200951 2022-02-10 Greene Indiana 18055 7000 130
2197697 2197697 2022-02-09 Greene Indiana 18055 6940 128
2194443 2194443 2022-02-08 Greene Indiana 18055 6940 128
2191189 2191189 2022-02-07 Greene Indiana 18055 6916 126
2187936 2187936 2022-02-06 Greene Indiana 18055 6889 126
2184683 2184683 2022-02-05 Greene Indiana 18055 6889 126
2181431 2181431 2022-02-04 Greene Indiana 18055 6889 126
2178180 2178180 2022-02-03 Greene Indiana 18055 6864 126

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