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

778 rows where county = "Caddo" and fips = 40015 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 40015 · 778 ✖

county 1

  • Caddo · 778 ✖
Link rowid date ▲ county state fips cases deaths
2501740 2501740 2022-05-13 Caddo Oklahoma 40015 8278 171
2498482 2498482 2022-05-12 Caddo Oklahoma 40015 8278 171
2495224 2495224 2022-05-11 Caddo Oklahoma 40015 8278 171
2491966 2491966 2022-05-10 Caddo Oklahoma 40015 8278 171
2488708 2488708 2022-05-09 Caddo Oklahoma 40015 8278 171
2485451 2485451 2022-05-08 Caddo Oklahoma 40015 8278 171
2482193 2482193 2022-05-07 Caddo Oklahoma 40015 8278 171
2478935 2478935 2022-05-06 Caddo Oklahoma 40015 8278 171
2475677 2475677 2022-05-05 Caddo Oklahoma 40015 8278 171
2472420 2472420 2022-05-04 Caddo Oklahoma 40015 8271 167
2469164 2469164 2022-05-03 Caddo Oklahoma 40015 8271 167
2465908 2465908 2022-05-02 Caddo Oklahoma 40015 8271 167
2462653 2462653 2022-05-01 Caddo Oklahoma 40015 8271 167
2459397 2459397 2022-04-30 Caddo Oklahoma 40015 8271 167
2456141 2456141 2022-04-29 Caddo Oklahoma 40015 8271 167
2452885 2452885 2022-04-28 Caddo Oklahoma 40015 8271 167
2449629 2449629 2022-04-27 Caddo Oklahoma 40015 8264 165
2446372 2446372 2022-04-26 Caddo Oklahoma 40015 8264 165
2443117 2443117 2022-04-25 Caddo Oklahoma 40015 8264 165
2439861 2439861 2022-04-24 Caddo Oklahoma 40015 8264 165
2436605 2436605 2022-04-23 Caddo Oklahoma 40015 8264 165
2433349 2433349 2022-04-22 Caddo Oklahoma 40015 8264 165
2430093 2430093 2022-04-21 Caddo Oklahoma 40015 8264 165
2426837 2426837 2022-04-20 Caddo Oklahoma 40015 8249 163
2423581 2423581 2022-04-19 Caddo Oklahoma 40015 8249 163
2420324 2420324 2022-04-18 Caddo Oklahoma 40015 8249 163
2417069 2417069 2022-04-17 Caddo Oklahoma 40015 8249 163
2413813 2413813 2022-04-16 Caddo Oklahoma 40015 8249 163
2410557 2410557 2022-04-15 Caddo Oklahoma 40015 8249 163
2407301 2407301 2022-04-14 Caddo Oklahoma 40015 8249 163
2404045 2404045 2022-04-13 Caddo Oklahoma 40015 8245 161
2400790 2400790 2022-04-12 Caddo Oklahoma 40015 8245 161
2397535 2397535 2022-04-11 Caddo Oklahoma 40015 8245 161
2394280 2394280 2022-04-10 Caddo Oklahoma 40015 8245 161
2391024 2391024 2022-04-09 Caddo Oklahoma 40015 8245 161
2387768 2387768 2022-04-08 Caddo Oklahoma 40015 8245 161
2384513 2384513 2022-04-07 Caddo Oklahoma 40015 8245 161
2381258 2381258 2022-04-06 Caddo Oklahoma 40015 8238 161
2378003 2378003 2022-04-05 Caddo Oklahoma 40015 8238 161
2374749 2374749 2022-04-04 Caddo Oklahoma 40015 8238 161
2371497 2371497 2022-04-03 Caddo Oklahoma 40015 8238 161
2368244 2368244 2022-04-02 Caddo Oklahoma 40015 8238 161
2364991 2364991 2022-04-01 Caddo Oklahoma 40015 8238 161
2361738 2361738 2022-03-31 Caddo Oklahoma 40015 8238 161
2358484 2358484 2022-03-30 Caddo Oklahoma 40015 8233 159
2355230 2355230 2022-03-29 Caddo Oklahoma 40015 8233 159
2351977 2351977 2022-03-28 Caddo Oklahoma 40015 8233 159
2348725 2348725 2022-03-27 Caddo Oklahoma 40015 8233 159
2345472 2345472 2022-03-26 Caddo Oklahoma 40015 8233 159
2342219 2342219 2022-03-25 Caddo Oklahoma 40015 8233 159
2338966 2338966 2022-03-24 Caddo Oklahoma 40015 8233 159
2335712 2335712 2022-03-23 Caddo Oklahoma 40015 8219 157
2332458 2332458 2022-03-22 Caddo Oklahoma 40015 8219 157
2329205 2329205 2022-03-21 Caddo Oklahoma 40015 8219 157
2325953 2325953 2022-03-20 Caddo Oklahoma 40015 8219 157
2322700 2322700 2022-03-19 Caddo Oklahoma 40015 8219 157
2319446 2319446 2022-03-18 Caddo Oklahoma 40015 8219 157
2316192 2316192 2022-03-17 Caddo Oklahoma 40015 8219 157
2312939 2312939 2022-03-16 Caddo Oklahoma 40015 8208 156
2309686 2309686 2022-03-15 Caddo Oklahoma 40015 8208 156
2306433 2306433 2022-03-14 Caddo Oklahoma 40015 8208 156
2303182 2303182 2022-03-13 Caddo Oklahoma 40015 8208 156
2299930 2299930 2022-03-12 Caddo Oklahoma 40015 8208 156
2296678 2296678 2022-03-11 Caddo Oklahoma 40015 8208 156
2293426 2293426 2022-03-10 Caddo Oklahoma 40015 8208 156
2290174 2290174 2022-03-09 Caddo Oklahoma 40015 8185 155
2286922 2286922 2022-03-08 Caddo Oklahoma 40015 8185 155
2283670 2283670 2022-03-07 Caddo Oklahoma 40015 8185 155
2280418 2280418 2022-03-06 Caddo Oklahoma 40015 8185 155
2277165 2277165 2022-03-05 Caddo Oklahoma 40015 8185 155
2273912 2273912 2022-03-04 Caddo Oklahoma 40015 8185 155
2270659 2270659 2022-03-03 Caddo Oklahoma 40015 8185 155
2267407 2267407 2022-03-02 Caddo Oklahoma 40015 8185 155
2264154 2264154 2022-03-01 Caddo Oklahoma 40015 8159 153
2260904 2260904 2022-02-28 Caddo Oklahoma 40015 8159 153
2257653 2257653 2022-02-27 Caddo Oklahoma 40015 8159 153
2254402 2254402 2022-02-26 Caddo Oklahoma 40015 8159 153
2251151 2251151 2022-02-25 Caddo Oklahoma 40015 8159 153
2247900 2247900 2022-02-24 Caddo Oklahoma 40015 8159 153
2244649 2244649 2022-02-23 Caddo Oklahoma 40015 8159 153
2241398 2241398 2022-02-22 Caddo Oklahoma 40015 8096 153
2238147 2238147 2022-02-21 Caddo Oklahoma 40015 8096 153
2234896 2234896 2022-02-20 Caddo Oklahoma 40015 8096 153
2231645 2231645 2022-02-19 Caddo Oklahoma 40015 8096 153
2228394 2228394 2022-02-18 Caddo Oklahoma 40015 8096 153
2225143 2225143 2022-02-17 Caddo Oklahoma 40015 8096 153
2221892 2221892 2022-02-16 Caddo Oklahoma 40015 8096 153
2218641 2218641 2022-02-15 Caddo Oklahoma 40015 8032 147
2215390 2215390 2022-02-14 Caddo Oklahoma 40015 8032 147
2212139 2212139 2022-02-13 Caddo Oklahoma 40015 8032 147
2208886 2208886 2022-02-12 Caddo Oklahoma 40015 8032 147
2205633 2205633 2022-02-11 Caddo Oklahoma 40015 8032 147
2202380 2202380 2022-02-10 Caddo Oklahoma 40015 8032 147
2199126 2199126 2022-02-09 Caddo Oklahoma 40015 8032 147
2195872 2195872 2022-02-08 Caddo Oklahoma 40015 7875 145
2192618 2192618 2022-02-07 Caddo Oklahoma 40015 7875 145
2189364 2189364 2022-02-06 Caddo Oklahoma 40015 7875 145
2186111 2186111 2022-02-05 Caddo Oklahoma 40015 7875 145
2182859 2182859 2022-02-04 Caddo Oklahoma 40015 7875 145
2179607 2179607 2022-02-03 Caddo Oklahoma 40015 7875 145

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