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 = "Carroll", fips = 28015 and state = "Mississippi" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Mississippi · 776 ✖

fips 1

  • 28015 · 776 ✖

county 1

  • Carroll · 776 ✖
Link rowid date ▲ county state fips cases deaths
2501000 2501000 2022-05-13 Carroll Mississippi 28015 2565 54
2497742 2497742 2022-05-12 Carroll Mississippi 28015 2565 54
2494484 2494484 2022-05-11 Carroll Mississippi 28015 2565 54
2491226 2491226 2022-05-10 Carroll Mississippi 28015 2565 54
2487969 2487969 2022-05-09 Carroll Mississippi 28015 2565 54
2484711 2484711 2022-05-08 Carroll Mississippi 28015 2563 53
2481453 2481453 2022-05-07 Carroll Mississippi 28015 2563 53
2478195 2478195 2022-05-06 Carroll Mississippi 28015 2563 53
2474937 2474937 2022-05-05 Carroll Mississippi 28015 2563 53
2471680 2471680 2022-05-04 Carroll Mississippi 28015 2563 53
2468424 2468424 2022-05-03 Carroll Mississippi 28015 2563 53
2465169 2465169 2022-05-02 Carroll Mississippi 28015 2563 53
2461913 2461913 2022-05-01 Carroll Mississippi 28015 2558 53
2458657 2458657 2022-04-30 Carroll Mississippi 28015 2558 53
2455401 2455401 2022-04-29 Carroll Mississippi 28015 2558 53
2452145 2452145 2022-04-28 Carroll Mississippi 28015 2558 53
2448889 2448889 2022-04-27 Carroll Mississippi 28015 2558 53
2445633 2445633 2022-04-26 Carroll Mississippi 28015 2558 53
2442377 2442377 2022-04-25 Carroll Mississippi 28015 2558 53
2439121 2439121 2022-04-24 Carroll Mississippi 28015 2558 53
2435865 2435865 2022-04-23 Carroll Mississippi 28015 2558 53
2432609 2432609 2022-04-22 Carroll Mississippi 28015 2558 53
2429353 2429353 2022-04-21 Carroll Mississippi 28015 2558 53
2426097 2426097 2022-04-20 Carroll Mississippi 28015 2558 53
2422841 2422841 2022-04-19 Carroll Mississippi 28015 2558 53
2419585 2419585 2022-04-18 Carroll Mississippi 28015 2558 53
2416329 2416329 2022-04-17 Carroll Mississippi 28015 2557 53
2413073 2413073 2022-04-16 Carroll Mississippi 28015 2557 53
2409817 2409817 2022-04-15 Carroll Mississippi 28015 2557 53
2406561 2406561 2022-04-14 Carroll Mississippi 28015 2557 53
2403305 2403305 2022-04-13 Carroll Mississippi 28015 2557 53
2400051 2400051 2022-04-12 Carroll Mississippi 28015 2557 53
2396795 2396795 2022-04-11 Carroll Mississippi 28015 2557 53
2393540 2393540 2022-04-10 Carroll Mississippi 28015 2557 53
2390284 2390284 2022-04-09 Carroll Mississippi 28015 2557 53
2387028 2387028 2022-04-08 Carroll Mississippi 28015 2557 53
2383773 2383773 2022-04-07 Carroll Mississippi 28015 2557 53
2380518 2380518 2022-04-06 Carroll Mississippi 28015 2557 53
2377263 2377263 2022-04-05 Carroll Mississippi 28015 2557 53
2374011 2374011 2022-04-04 Carroll Mississippi 28015 2557 53
2370758 2370758 2022-04-03 Carroll Mississippi 28015 2557 53
2367505 2367505 2022-04-02 Carroll Mississippi 28015 2557 53
2364252 2364252 2022-04-01 Carroll Mississippi 28015 2557 53
2360998 2360998 2022-03-31 Carroll Mississippi 28015 2557 53
2357744 2357744 2022-03-30 Carroll Mississippi 28015 2557 53
2354491 2354491 2022-03-29 Carroll Mississippi 28015 2557 53
2351239 2351239 2022-03-28 Carroll Mississippi 28015 2557 53
2347986 2347986 2022-03-27 Carroll Mississippi 28015 2557 52
2344733 2344733 2022-03-26 Carroll Mississippi 28015 2557 52
2341480 2341480 2022-03-25 Carroll Mississippi 28015 2557 52
2338227 2338227 2022-03-24 Carroll Mississippi 28015 2557 52
2334973 2334973 2022-03-23 Carroll Mississippi 28015 2557 52
2331719 2331719 2022-03-22 Carroll Mississippi 28015 2557 52
2328467 2328467 2022-03-21 Carroll Mississippi 28015 2557 52
2325214 2325214 2022-03-20 Carroll Mississippi 28015 2556 50
2321960 2321960 2022-03-19 Carroll Mississippi 28015 2556 50
2318706 2318706 2022-03-18 Carroll Mississippi 28015 2556 50
2315453 2315453 2022-03-17 Carroll Mississippi 28015 2556 50
2312200 2312200 2022-03-16 Carroll Mississippi 28015 2556 50
2308947 2308947 2022-03-15 Carroll Mississippi 28015 2556 50
2305696 2305696 2022-03-14 Carroll Mississippi 28015 2556 50
2302444 2302444 2022-03-13 Carroll Mississippi 28015 2556 50
2299192 2299192 2022-03-12 Carroll Mississippi 28015 2556 50
2295940 2295940 2022-03-11 Carroll Mississippi 28015 2556 50
2292688 2292688 2022-03-10 Carroll Mississippi 28015 2556 50
2289436 2289436 2022-03-09 Carroll Mississippi 28015 2556 50
2286185 2286185 2022-03-08 Carroll Mississippi 28015 2556 50
2282933 2282933 2022-03-07 Carroll Mississippi 28015 2556 50
2279680 2279680 2022-03-06 Carroll Mississippi 28015 2555 50
2276427 2276427 2022-03-05 Carroll Mississippi 28015 2555 50
2273174 2273174 2022-03-04 Carroll Mississippi 28015 2555 50
2269922 2269922 2022-03-03 Carroll Mississippi 28015 2555 50
2266669 2266669 2022-03-02 Carroll Mississippi 28015 2554 50
2263418 2263418 2022-03-01 Carroll Mississippi 28015 2548 50
2260167 2260167 2022-02-28 Carroll Mississippi 28015 2547 50
2256916 2256916 2022-02-27 Carroll Mississippi 28015 2546 50
2253665 2253665 2022-02-26 Carroll Mississippi 28015 2546 50
2250414 2250414 2022-02-25 Carroll Mississippi 28015 2546 50
2247163 2247163 2022-02-24 Carroll Mississippi 28015 2546 50
2243912 2243912 2022-02-23 Carroll Mississippi 28015 2546 50
2240661 2240661 2022-02-22 Carroll Mississippi 28015 2545 50
2237410 2237410 2022-02-21 Carroll Mississippi 28015 2537 50
2234159 2234159 2022-02-20 Carroll Mississippi 28015 2537 50
2230908 2230908 2022-02-19 Carroll Mississippi 28015 2537 50
2227657 2227657 2022-02-18 Carroll Mississippi 28015 2537 50
2224406 2224406 2022-02-17 Carroll Mississippi 28015 2534 49
2221155 2221155 2022-02-16 Carroll Mississippi 28015 2534 49
2217904 2217904 2022-02-15 Carroll Mississippi 28015 2530 49
2214653 2214653 2022-02-14 Carroll Mississippi 28015 2527 49
2211401 2211401 2022-02-13 Carroll Mississippi 28015 2512 48
2208148 2208148 2022-02-12 Carroll Mississippi 28015 2512 48
2204895 2204895 2022-02-11 Carroll Mississippi 28015 2512 48
2201642 2201642 2022-02-10 Carroll Mississippi 28015 2499 48
2198388 2198388 2022-02-09 Carroll Mississippi 28015 2496 48
2195134 2195134 2022-02-08 Carroll Mississippi 28015 2491 48
2191880 2191880 2022-02-07 Carroll Mississippi 28015 2485 48
2188627 2188627 2022-02-06 Carroll Mississippi 28015 2452 47
2185374 2185374 2022-02-05 Carroll Mississippi 28015 2452 47
2182122 2182122 2022-02-04 Carroll Mississippi 28015 2452 47
2178870 2178870 2022-02-03 Carroll Mississippi 28015 2441 46

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