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

782 rows where county = "Camden" and state = "Missouri" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Missouri · 782 ✖

fips 1

  • 29029 782

county 1

  • Camden · 782 ✖
Link rowid date ▲ county state fips cases deaths
2501090 2501090 2022-05-13 Camden Missouri 29029 9331 180
2497832 2497832 2022-05-12 Camden Missouri 29029 9314 180
2494574 2494574 2022-05-11 Camden Missouri 29029 9314 180
2491316 2491316 2022-05-10 Camden Missouri 29029 9314 180
2488058 2488058 2022-05-09 Camden Missouri 29029 9314 180
2484801 2484801 2022-05-08 Camden Missouri 29029 9314 180
2481543 2481543 2022-05-07 Camden Missouri 29029 9314 180
2478285 2478285 2022-05-06 Camden Missouri 29029 9314 180
2475027 2475027 2022-05-05 Camden Missouri 29029 9290 180
2471770 2471770 2022-05-04 Camden Missouri 29029 9280 179
2468514 2468514 2022-05-03 Camden Missouri 29029 9280 179
2465258 2465258 2022-05-02 Camden Missouri 29029 9280 179
2462003 2462003 2022-05-01 Camden Missouri 29029 9280 179
2458747 2458747 2022-04-30 Camden Missouri 29029 9280 179
2455491 2455491 2022-04-29 Camden Missouri 29029 9280 179
2452235 2452235 2022-04-28 Camden Missouri 29029 9280 179
2448979 2448979 2022-04-27 Camden Missouri 29029 9280 179
2445722 2445722 2022-04-26 Camden Missouri 29029 9280 179
2442467 2442467 2022-04-25 Camden Missouri 29029 9280 179
2439211 2439211 2022-04-24 Camden Missouri 29029 9280 179
2435955 2435955 2022-04-23 Camden Missouri 29029 9280 179
2432699 2432699 2022-04-22 Camden Missouri 29029 9280 179
2429443 2429443 2022-04-21 Camden Missouri 29029 9280 179
2426187 2426187 2022-04-20 Camden Missouri 29029 9280 179
2422931 2422931 2022-04-19 Camden Missouri 29029 9280 179
2419674 2419674 2022-04-18 Camden Missouri 29029 9280 179
2416419 2416419 2022-04-17 Camden Missouri 29029 9280 179
2413163 2413163 2022-04-16 Camden Missouri 29029 9280 179
2409907 2409907 2022-04-15 Camden Missouri 29029 9280 179
2406651 2406651 2022-04-14 Camden Missouri 29029 9280 179
2403395 2403395 2022-04-13 Camden Missouri 29029 9280 179
2400140 2400140 2022-04-12 Camden Missouri 29029 9280 179
2396885 2396885 2022-04-11 Camden Missouri 29029 9280 179
2393630 2393630 2022-04-10 Camden Missouri 29029 9280 179
2390374 2390374 2022-04-09 Camden Missouri 29029 9280 179
2387118 2387118 2022-04-08 Camden Missouri 29029 9280 179
2383863 2383863 2022-04-07 Camden Missouri 29029 9280 179
2380608 2380608 2022-04-06 Camden Missouri 29029 9280 179
2377353 2377353 2022-04-05 Camden Missouri 29029 9280 179
2374100 2374100 2022-04-04 Camden Missouri 29029 9280 179
2370848 2370848 2022-04-03 Camden Missouri 29029 9280 179
2367595 2367595 2022-04-02 Camden Missouri 29029 9280 179
2364342 2364342 2022-04-01 Camden Missouri 29029 9280 179
2361088 2361088 2022-03-31 Camden Missouri 29029 9280 179
2357834 2357834 2022-03-30 Camden Missouri 29029 9279 178
2354581 2354581 2022-03-29 Camden Missouri 29029 9277 178
2351328 2351328 2022-03-28 Camden Missouri 29029 9272 176
2348076 2348076 2022-03-27 Camden Missouri 29029 9271 176
2344823 2344823 2022-03-26 Camden Missouri 29029 9271 176
2341570 2341570 2022-03-25 Camden Missouri 29029 9271 176
2338317 2338317 2022-03-24 Camden Missouri 29029 9270 176
2335063 2335063 2022-03-23 Camden Missouri 29029 9268 176
2331809 2331809 2022-03-22 Camden Missouri 29029 9264 176
2328556 2328556 2022-03-21 Camden Missouri 29029 9259 175
2325304 2325304 2022-03-20 Camden Missouri 29029 9259 175
2322050 2322050 2022-03-19 Camden Missouri 29029 9259 175
2318796 2318796 2022-03-18 Camden Missouri 29029 9259 175
2315543 2315543 2022-03-17 Camden Missouri 29029 9252 175
2312290 2312290 2022-03-16 Camden Missouri 29029 9251 176
2309037 2309037 2022-03-15 Camden Missouri 29029 9248 176
2305785 2305785 2022-03-14 Camden Missouri 29029 9244 173
2302534 2302534 2022-03-13 Camden Missouri 29029 9240 173
2299282 2299282 2022-03-12 Camden Missouri 29029 9240 173
2296030 2296030 2022-03-11 Camden Missouri 29029 9240 173
2292778 2292778 2022-03-10 Camden Missouri 29029 9238 173
2289526 2289526 2022-03-09 Camden Missouri 29029 9230 173
2286274 2286274 2022-03-08 Camden Missouri 29029 9230 173
2283022 2283022 2022-03-07 Camden Missouri 29029 9227 171
2279769 2279769 2022-03-06 Camden Missouri 29029 9224 171
2276516 2276516 2022-03-05 Camden Missouri 29029 9224 171
2273263 2273263 2022-03-04 Camden Missouri 29029 9224 171
2270011 2270011 2022-03-03 Camden Missouri 29029 9220 171
2266758 2266758 2022-03-02 Camden Missouri 29029 9219 171
2263507 2263507 2022-03-01 Camden Missouri 29029 9213 171
2260256 2260256 2022-02-28 Camden Missouri 29029 9209 171
2257005 2257005 2022-02-27 Camden Missouri 29029 9204 171
2253754 2253754 2022-02-26 Camden Missouri 29029 9204 171
2250503 2250503 2022-02-25 Camden Missouri 29029 9204 171
2247252 2247252 2022-02-24 Camden Missouri 29029 9201 171
2244001 2244001 2022-02-23 Camden Missouri 29029 9193 165
2240750 2240750 2022-02-22 Camden Missouri 29029 9183 165
2237499 2237499 2022-02-21 Camden Missouri 29029 9164 165
2234248 2234248 2022-02-20 Camden Missouri 29029 9164 165
2230997 2230997 2022-02-19 Camden Missouri 29029 9164 165
2227746 2227746 2022-02-18 Camden Missouri 29029 9164 165
2224495 2224495 2022-02-17 Camden Missouri 29029 9154 165
2221244 2221244 2022-02-16 Camden Missouri 29029 9148 165
2217993 2217993 2022-02-15 Camden Missouri 29029 9133 165
2214742 2214742 2022-02-14 Camden Missouri 29029 9126 165
2211490 2211490 2022-02-13 Camden Missouri 29029 9084 165
2208237 2208237 2022-02-12 Camden Missouri 29029 9084 165
2204984 2204984 2022-02-11 Camden Missouri 29029 9084 165
2201731 2201731 2022-02-10 Camden Missouri 29029 9084 165
2198477 2198477 2022-02-09 Camden Missouri 29029 9056 165
2195223 2195223 2022-02-08 Camden Missouri 29029 9031 165
2191969 2191969 2022-02-07 Camden Missouri 29029 9008 165
2188716 2188716 2022-02-06 Camden Missouri 29029 8993 165
2185463 2185463 2022-02-05 Camden Missouri 29029 8987 165
2182211 2182211 2022-02-04 Camden Missouri 29029 8979 165
2178959 2178959 2022-02-03 Camden Missouri 29029 8964 165

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