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

780 rows where county = "Jackson" and fips = 22049 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Louisiana 780

fips 1

  • 22049 · 780 ✖

county 1

  • Jackson · 780 ✖
Link rowid date ▲ county state fips cases deaths
2500723 2500723 2022-05-13 Jackson Louisiana 22049 4409 76
2497465 2497465 2022-05-12 Jackson Louisiana 22049 4409 76
2494207 2494207 2022-05-11 Jackson Louisiana 22049 4409 76
2490949 2490949 2022-05-10 Jackson Louisiana 22049 4409 76
2487692 2487692 2022-05-09 Jackson Louisiana 22049 4408 76
2484434 2484434 2022-05-08 Jackson Louisiana 22049 4408 76
2481176 2481176 2022-05-07 Jackson Louisiana 22049 4408 76
2477918 2477918 2022-05-06 Jackson Louisiana 22049 4408 76
2474660 2474660 2022-05-05 Jackson Louisiana 22049 4408 76
2471403 2471403 2022-05-04 Jackson Louisiana 22049 4408 76
2468147 2468147 2022-05-03 Jackson Louisiana 22049 4408 76
2464892 2464892 2022-05-02 Jackson Louisiana 22049 4407 75
2461636 2461636 2022-05-01 Jackson Louisiana 22049 4407 75
2458380 2458380 2022-04-30 Jackson Louisiana 22049 4407 75
2455124 2455124 2022-04-29 Jackson Louisiana 22049 4407 75
2451868 2451868 2022-04-28 Jackson Louisiana 22049 4404 75
2448612 2448612 2022-04-27 Jackson Louisiana 22049 4402 75
2445356 2445356 2022-04-26 Jackson Louisiana 22049 4402 75
2442100 2442100 2022-04-25 Jackson Louisiana 22049 4402 75
2438844 2438844 2022-04-24 Jackson Louisiana 22049 4398 75
2435588 2435588 2022-04-23 Jackson Louisiana 22049 4398 75
2432332 2432332 2022-04-22 Jackson Louisiana 22049 4398 75
2429076 2429076 2022-04-21 Jackson Louisiana 22049 4396 75
2425820 2425820 2022-04-20 Jackson Louisiana 22049 4396 75
2422564 2422564 2022-04-19 Jackson Louisiana 22049 4395 75
2419308 2419308 2022-04-18 Jackson Louisiana 22049 4394 75
2416052 2416052 2022-04-17 Jackson Louisiana 22049 4390 75
2412796 2412796 2022-04-16 Jackson Louisiana 22049 4390 75
2409540 2409540 2022-04-15 Jackson Louisiana 22049 4390 75
2406284 2406284 2022-04-14 Jackson Louisiana 22049 4390 75
2403028 2403028 2022-04-13 Jackson Louisiana 22049 4389 75
2399774 2399774 2022-04-12 Jackson Louisiana 22049 4389 75
2396518 2396518 2022-04-11 Jackson Louisiana 22049 4389 75
2393263 2393263 2022-04-10 Jackson Louisiana 22049 4386 75
2390007 2390007 2022-04-09 Jackson Louisiana 22049 4386 75
2386751 2386751 2022-04-08 Jackson Louisiana 22049 4386 75
2383496 2383496 2022-04-07 Jackson Louisiana 22049 4381 75
2380241 2380241 2022-04-06 Jackson Louisiana 22049 4381 75
2376986 2376986 2022-04-05 Jackson Louisiana 22049 4380 75
2373734 2373734 2022-04-04 Jackson Louisiana 22049 4379 75
2370481 2370481 2022-04-03 Jackson Louisiana 22049 4378 75
2367228 2367228 2022-04-02 Jackson Louisiana 22049 4378 75
2363975 2363975 2022-04-01 Jackson Louisiana 22049 4378 75
2360721 2360721 2022-03-31 Jackson Louisiana 22049 4378 75
2357467 2357467 2022-03-30 Jackson Louisiana 22049 4377 75
2354214 2354214 2022-03-29 Jackson Louisiana 22049 4374 75
2350962 2350962 2022-03-28 Jackson Louisiana 22049 4374 75
2347709 2347709 2022-03-27 Jackson Louisiana 22049 4372 75
2344456 2344456 2022-03-26 Jackson Louisiana 22049 4372 75
2341203 2341203 2022-03-25 Jackson Louisiana 22049 4372 75
2337950 2337950 2022-03-24 Jackson Louisiana 22049 4371 74
2334696 2334696 2022-03-23 Jackson Louisiana 22049 4370 74
2331442 2331442 2022-03-22 Jackson Louisiana 22049 4370 74
2328190 2328190 2022-03-21 Jackson Louisiana 22049 4370 74
2324937 2324937 2022-03-20 Jackson Louisiana 22049 4367 74
2321683 2321683 2022-03-19 Jackson Louisiana 22049 4367 74
2318429 2318429 2022-03-18 Jackson Louisiana 22049 4367 74
2315176 2315176 2022-03-17 Jackson Louisiana 22049 4363 74
2311923 2311923 2022-03-16 Jackson Louisiana 22049 4363 74
2308670 2308670 2022-03-15 Jackson Louisiana 22049 4363 74
2305419 2305419 2022-03-14 Jackson Louisiana 22049 4362 73
2302167 2302167 2022-03-13 Jackson Louisiana 22049 4346 73
2298915 2298915 2022-03-12 Jackson Louisiana 22049 4346 73
2295663 2295663 2022-03-11 Jackson Louisiana 22049 4346 73
2292411 2292411 2022-03-10 Jackson Louisiana 22049 4346 72
2289159 2289159 2022-03-09 Jackson Louisiana 22049 4344 72
2285908 2285908 2022-03-08 Jackson Louisiana 22049 4334 72
2282656 2282656 2022-03-07 Jackson Louisiana 22049 4334 72
2279403 2279403 2022-03-06 Jackson Louisiana 22049 4334 72
2276150 2276150 2022-03-05 Jackson Louisiana 22049 4334 72
2272897 2272897 2022-03-04 Jackson Louisiana 22049 4334 72
2269645 2269645 2022-03-03 Jackson Louisiana 22049 4333 72
2266392 2266392 2022-03-02 Jackson Louisiana 22049 4332 72
2263141 2263141 2022-03-01 Jackson Louisiana 22049 4329 71
2259890 2259890 2022-02-28 Jackson Louisiana 22049 4329 71
2256639 2256639 2022-02-27 Jackson Louisiana 22049 4329 71
2253388 2253388 2022-02-26 Jackson Louisiana 22049 4329 71
2250137 2250137 2022-02-25 Jackson Louisiana 22049 4329 71
2246886 2246886 2022-02-24 Jackson Louisiana 22049 4324 71
2243635 2243635 2022-02-23 Jackson Louisiana 22049 4322 71
2240384 2240384 2022-02-22 Jackson Louisiana 22049 4322 71
2237133 2237133 2022-02-21 Jackson Louisiana 22049 4310 71
2233882 2233882 2022-02-20 Jackson Louisiana 22049 4298 71
2230631 2230631 2022-02-19 Jackson Louisiana 22049 4298 71
2227380 2227380 2022-02-18 Jackson Louisiana 22049 4298 71
2224129 2224129 2022-02-17 Jackson Louisiana 22049 4288 70
2220878 2220878 2022-02-16 Jackson Louisiana 22049 4277 70
2217627 2217627 2022-02-15 Jackson Louisiana 22049 4268 70
2214376 2214376 2022-02-14 Jackson Louisiana 22049 4260 70
2211124 2211124 2022-02-13 Jackson Louisiana 22049 4252 70
2207871 2207871 2022-02-12 Jackson Louisiana 22049 4252 70
2204618 2204618 2022-02-11 Jackson Louisiana 22049 4252 70
2201365 2201365 2022-02-10 Jackson Louisiana 22049 4231 70
2198111 2198111 2022-02-09 Jackson Louisiana 22049 4209 68
2194857 2194857 2022-02-08 Jackson Louisiana 22049 4201 68
2191603 2191603 2022-02-07 Jackson Louisiana 22049 4192 68
2188350 2188350 2022-02-06 Jackson Louisiana 22049 4174 68
2185097 2185097 2022-02-05 Jackson Louisiana 22049 4174 68
2181845 2181845 2022-02-04 Jackson Louisiana 22049 4174 68
2178594 2178594 2022-02-03 Jackson Louisiana 22049 4150 67

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