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

787 rows where county = "Bolivar" 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

county 1

  • Bolivar · 787 ✖
Link rowid date ▲ county state fips cases deaths
2500998 2500998 2022-05-13 Bolivar Mississippi 28011 9354 179
2497740 2497740 2022-05-12 Bolivar Mississippi 28011 9354 179
2494482 2494482 2022-05-11 Bolivar Mississippi 28011 9354 179
2491224 2491224 2022-05-10 Bolivar Mississippi 28011 9354 179
2487967 2487967 2022-05-09 Bolivar Mississippi 28011 9354 179
2484709 2484709 2022-05-08 Bolivar Mississippi 28011 9335 179
2481451 2481451 2022-05-07 Bolivar Mississippi 28011 9335 179
2478193 2478193 2022-05-06 Bolivar Mississippi 28011 9335 179
2474935 2474935 2022-05-05 Bolivar Mississippi 28011 9335 179
2471678 2471678 2022-05-04 Bolivar Mississippi 28011 9335 179
2468422 2468422 2022-05-03 Bolivar Mississippi 28011 9335 179
2465167 2465167 2022-05-02 Bolivar Mississippi 28011 9335 179
2461911 2461911 2022-05-01 Bolivar Mississippi 28011 9312 179
2458655 2458655 2022-04-30 Bolivar Mississippi 28011 9312 179
2455399 2455399 2022-04-29 Bolivar Mississippi 28011 9312 179
2452143 2452143 2022-04-28 Bolivar Mississippi 28011 9312 179
2448887 2448887 2022-04-27 Bolivar Mississippi 28011 9312 179
2445631 2445631 2022-04-26 Bolivar Mississippi 28011 9312 179
2442375 2442375 2022-04-25 Bolivar Mississippi 28011 9295 179
2439119 2439119 2022-04-24 Bolivar Mississippi 28011 9295 179
2435863 2435863 2022-04-23 Bolivar Mississippi 28011 9295 179
2432607 2432607 2022-04-22 Bolivar Mississippi 28011 9295 179
2429351 2429351 2022-04-21 Bolivar Mississippi 28011 9295 179
2426095 2426095 2022-04-20 Bolivar Mississippi 28011 9295 179
2422839 2422839 2022-04-19 Bolivar Mississippi 28011 9295 179
2419583 2419583 2022-04-18 Bolivar Mississippi 28011 9295 179
2416327 2416327 2022-04-17 Bolivar Mississippi 28011 9285 179
2413071 2413071 2022-04-16 Bolivar Mississippi 28011 9285 179
2409815 2409815 2022-04-15 Bolivar Mississippi 28011 9285 179
2406559 2406559 2022-04-14 Bolivar Mississippi 28011 9285 179
2403303 2403303 2022-04-13 Bolivar Mississippi 28011 9285 179
2400049 2400049 2022-04-12 Bolivar Mississippi 28011 9285 179
2396793 2396793 2022-04-11 Bolivar Mississippi 28011 9278 179
2393538 2393538 2022-04-10 Bolivar Mississippi 28011 9278 179
2390282 2390282 2022-04-09 Bolivar Mississippi 28011 9278 179
2387026 2387026 2022-04-08 Bolivar Mississippi 28011 9278 179
2383771 2383771 2022-04-07 Bolivar Mississippi 28011 9278 179
2380516 2380516 2022-04-06 Bolivar Mississippi 28011 9278 179
2377261 2377261 2022-04-05 Bolivar Mississippi 28011 9278 179
2374009 2374009 2022-04-04 Bolivar Mississippi 28011 9278 179
2370756 2370756 2022-04-03 Bolivar Mississippi 28011 9269 179
2367503 2367503 2022-04-02 Bolivar Mississippi 28011 9269 179
2364250 2364250 2022-04-01 Bolivar Mississippi 28011 9269 179
2360996 2360996 2022-03-31 Bolivar Mississippi 28011 9269 179
2357742 2357742 2022-03-30 Bolivar Mississippi 28011 9269 179
2354489 2354489 2022-03-29 Bolivar Mississippi 28011 9269 179
2351237 2351237 2022-03-28 Bolivar Mississippi 28011 9269 179
2347984 2347984 2022-03-27 Bolivar Mississippi 28011 9264 179
2344731 2344731 2022-03-26 Bolivar Mississippi 28011 9264 179
2341478 2341478 2022-03-25 Bolivar Mississippi 28011 9264 179
2338225 2338225 2022-03-24 Bolivar Mississippi 28011 9264 179
2334971 2334971 2022-03-23 Bolivar Mississippi 28011 9264 179
2331717 2331717 2022-03-22 Bolivar Mississippi 28011 9264 179
2328465 2328465 2022-03-21 Bolivar Mississippi 28011 9264 179
2325212 2325212 2022-03-20 Bolivar Mississippi 28011 9245 178
2321958 2321958 2022-03-19 Bolivar Mississippi 28011 9245 178
2318704 2318704 2022-03-18 Bolivar Mississippi 28011 9245 178
2315451 2315451 2022-03-17 Bolivar Mississippi 28011 9245 178
2312198 2312198 2022-03-16 Bolivar Mississippi 28011 9245 178
2308945 2308945 2022-03-15 Bolivar Mississippi 28011 9245 178
2305694 2305694 2022-03-14 Bolivar Mississippi 28011 9245 178
2302442 2302442 2022-03-13 Bolivar Mississippi 28011 9238 177
2299190 2299190 2022-03-12 Bolivar Mississippi 28011 9238 177
2295938 2295938 2022-03-11 Bolivar Mississippi 28011 9238 177
2292686 2292686 2022-03-10 Bolivar Mississippi 28011 9238 177
2289434 2289434 2022-03-09 Bolivar Mississippi 28011 9238 177
2286183 2286183 2022-03-08 Bolivar Mississippi 28011 9238 177
2282931 2282931 2022-03-07 Bolivar Mississippi 28011 9235 177
2279678 2279678 2022-03-06 Bolivar Mississippi 28011 9219 177
2276425 2276425 2022-03-05 Bolivar Mississippi 28011 9219 177
2273172 2273172 2022-03-04 Bolivar Mississippi 28011 9219 177
2269920 2269920 2022-03-03 Bolivar Mississippi 28011 9216 177
2266667 2266667 2022-03-02 Bolivar Mississippi 28011 9215 177
2263416 2263416 2022-03-01 Bolivar Mississippi 28011 9210 176
2260165 2260165 2022-02-28 Bolivar Mississippi 28011 9208 174
2256914 2256914 2022-02-27 Bolivar Mississippi 28011 9198 174
2253663 2253663 2022-02-26 Bolivar Mississippi 28011 9198 174
2250412 2250412 2022-02-25 Bolivar Mississippi 28011 9198 174
2247161 2247161 2022-02-24 Bolivar Mississippi 28011 9192 174
2243910 2243910 2022-02-23 Bolivar Mississippi 28011 9182 173
2240659 2240659 2022-02-22 Bolivar Mississippi 28011 9170 171
2237408 2237408 2022-02-21 Bolivar Mississippi 28011 9138 170
2234157 2234157 2022-02-20 Bolivar Mississippi 28011 9138 170
2230906 2230906 2022-02-19 Bolivar Mississippi 28011 9138 170
2227655 2227655 2022-02-18 Bolivar Mississippi 28011 9138 170
2224404 2224404 2022-02-17 Bolivar Mississippi 28011 9121 168
2221153 2221153 2022-02-16 Bolivar Mississippi 28011 9114 168
2217902 2217902 2022-02-15 Bolivar Mississippi 28011 9101 166
2214651 2214651 2022-02-14 Bolivar Mississippi 28011 9088 166
2211399 2211399 2022-02-13 Bolivar Mississippi 28011 9014 164
2208146 2208146 2022-02-12 Bolivar Mississippi 28011 9014 164
2204893 2204893 2022-02-11 Bolivar Mississippi 28011 9014 164
2201640 2201640 2022-02-10 Bolivar Mississippi 28011 9006 162
2198386 2198386 2022-02-09 Bolivar Mississippi 28011 8981 162
2195132 2195132 2022-02-08 Bolivar Mississippi 28011 8935 162
2191878 2191878 2022-02-07 Bolivar Mississippi 28011 8892 160
2188625 2188625 2022-02-06 Bolivar Mississippi 28011 8711 160
2185372 2185372 2022-02-05 Bolivar Mississippi 28011 8711 160
2182120 2182120 2022-02-04 Bolivar Mississippi 28011 8711 160
2178868 2178868 2022-02-03 Bolivar Mississippi 28011 8612 160

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