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

785 rows where county = "Ramsey" and state = "North Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • North Dakota · 785 ✖

fips 1

county 1

  • Ramsey · 785 ✖
Link rowid date ▲ county state fips cases deaths
2501621 2501621 2022-05-13 Ramsey North Dakota 38071 3638 57
2498363 2498363 2022-05-12 Ramsey North Dakota 38071 3628 57
2495105 2495105 2022-05-11 Ramsey North Dakota 38071 3628 57
2491847 2491847 2022-05-10 Ramsey North Dakota 38071 3628 57
2488589 2488589 2022-05-09 Ramsey North Dakota 38071 3628 57
2485332 2485332 2022-05-08 Ramsey North Dakota 38071 3628 57
2482074 2482074 2022-05-07 Ramsey North Dakota 38071 3628 57
2478816 2478816 2022-05-06 Ramsey North Dakota 38071 3628 57
2475558 2475558 2022-05-05 Ramsey North Dakota 38071 3624 57
2472301 2472301 2022-05-04 Ramsey North Dakota 38071 3624 57
2469045 2469045 2022-05-03 Ramsey North Dakota 38071 3624 57
2465789 2465789 2022-05-02 Ramsey North Dakota 38071 3624 57
2462534 2462534 2022-05-01 Ramsey North Dakota 38071 3624 57
2459278 2459278 2022-04-30 Ramsey North Dakota 38071 3624 57
2456022 2456022 2022-04-29 Ramsey North Dakota 38071 3624 57
2452766 2452766 2022-04-28 Ramsey North Dakota 38071 3620 57
2449510 2449510 2022-04-27 Ramsey North Dakota 38071 3620 57
2446253 2446253 2022-04-26 Ramsey North Dakota 38071 3620 57
2442998 2442998 2022-04-25 Ramsey North Dakota 38071 3620 57
2439742 2439742 2022-04-24 Ramsey North Dakota 38071 3620 57
2436486 2436486 2022-04-23 Ramsey North Dakota 38071 3620 57
2433230 2433230 2022-04-22 Ramsey North Dakota 38071 3620 57
2429974 2429974 2022-04-21 Ramsey North Dakota 38071 3618 57
2426718 2426718 2022-04-20 Ramsey North Dakota 38071 3618 57
2423462 2423462 2022-04-19 Ramsey North Dakota 38071 3618 57
2420205 2420205 2022-04-18 Ramsey North Dakota 38071 3618 57
2416950 2416950 2022-04-17 Ramsey North Dakota 38071 3618 57
2413694 2413694 2022-04-16 Ramsey North Dakota 38071 3618 57
2410438 2410438 2022-04-15 Ramsey North Dakota 38071 3618 57
2407182 2407182 2022-04-14 Ramsey North Dakota 38071 3611 57
2403926 2403926 2022-04-13 Ramsey North Dakota 38071 3611 57
2400671 2400671 2022-04-12 Ramsey North Dakota 38071 3611 57
2397416 2397416 2022-04-11 Ramsey North Dakota 38071 3611 57
2394161 2394161 2022-04-10 Ramsey North Dakota 38071 3611 57
2390905 2390905 2022-04-09 Ramsey North Dakota 38071 3611 57
2387649 2387649 2022-04-08 Ramsey North Dakota 38071 3611 57
2384394 2384394 2022-04-07 Ramsey North Dakota 38071 3608 57
2381139 2381139 2022-04-06 Ramsey North Dakota 38071 3608 57
2377884 2377884 2022-04-05 Ramsey North Dakota 38071 3608 57
2374631 2374631 2022-04-04 Ramsey North Dakota 38071 3608 57
2371379 2371379 2022-04-03 Ramsey North Dakota 38071 3608 57
2368126 2368126 2022-04-02 Ramsey North Dakota 38071 3608 57
2364873 2364873 2022-04-01 Ramsey North Dakota 38071 3608 57
2361619 2361619 2022-03-31 Ramsey North Dakota 38071 3607 57
2358365 2358365 2022-03-30 Ramsey North Dakota 38071 3607 57
2355111 2355111 2022-03-29 Ramsey North Dakota 38071 3607 57
2351858 2351858 2022-03-28 Ramsey North Dakota 38071 3607 57
2348606 2348606 2022-03-27 Ramsey North Dakota 38071 3607 57
2345353 2345353 2022-03-26 Ramsey North Dakota 38071 3607 57
2342100 2342100 2022-03-25 Ramsey North Dakota 38071 3607 57
2338847 2338847 2022-03-24 Ramsey North Dakota 38071 3606 57
2335593 2335593 2022-03-23 Ramsey North Dakota 38071 3606 57
2332339 2332339 2022-03-22 Ramsey North Dakota 38071 3606 57
2329086 2329086 2022-03-21 Ramsey North Dakota 38071 3606 57
2325834 2325834 2022-03-20 Ramsey North Dakota 38071 3606 57
2322581 2322581 2022-03-19 Ramsey North Dakota 38071 3606 57
2319327 2319327 2022-03-18 Ramsey North Dakota 38071 3606 57
2316073 2316073 2022-03-17 Ramsey North Dakota 38071 3605 57
2312820 2312820 2022-03-16 Ramsey North Dakota 38071 3605 57
2309567 2309567 2022-03-15 Ramsey North Dakota 38071 3605 57
2306314 2306314 2022-03-14 Ramsey North Dakota 38071 3605 57
2303063 2303063 2022-03-13 Ramsey North Dakota 38071 3605 57
2299811 2299811 2022-03-12 Ramsey North Dakota 38071 3605 57
2296559 2296559 2022-03-11 Ramsey North Dakota 38071 3607 56
2293307 2293307 2022-03-10 Ramsey North Dakota 38071 3610 56
2290055 2290055 2022-03-09 Ramsey North Dakota 38071 3611 56
2286803 2286803 2022-03-08 Ramsey North Dakota 38071 3613 55
2283551 2283551 2022-03-07 Ramsey North Dakota 38071 3613 55
2280299 2280299 2022-03-06 Ramsey North Dakota 38071 3613 55
2277046 2277046 2022-03-05 Ramsey North Dakota 38071 3613 55
2273793 2273793 2022-03-04 Ramsey North Dakota 38071 3610 55
2270540 2270540 2022-03-03 Ramsey North Dakota 38071 3608 55
2267288 2267288 2022-03-02 Ramsey North Dakota 38071 3605 55
2264036 2264036 2022-03-01 Ramsey North Dakota 38071 3600 55
2260785 2260785 2022-02-28 Ramsey North Dakota 38071 3599 55
2257534 2257534 2022-02-27 Ramsey North Dakota 38071 3599 55
2254283 2254283 2022-02-26 Ramsey North Dakota 38071 3597 55
2251032 2251032 2022-02-25 Ramsey North Dakota 38071 3597 55
2247781 2247781 2022-02-24 Ramsey North Dakota 38071 3594 55
2244530 2244530 2022-02-23 Ramsey North Dakota 38071 3586 54
2241279 2241279 2022-02-22 Ramsey North Dakota 38071 3581 54
2238028 2238028 2022-02-21 Ramsey North Dakota 38071 3582 54
2234777 2234777 2022-02-20 Ramsey North Dakota 38071 3578 54
2231526 2231526 2022-02-19 Ramsey North Dakota 38071 3577 54
2228275 2228275 2022-02-18 Ramsey North Dakota 38071 3567 54
2225024 2225024 2022-02-17 Ramsey North Dakota 38071 3563 54
2221773 2221773 2022-02-16 Ramsey North Dakota 38071 3547 54
2218522 2218522 2022-02-15 Ramsey North Dakota 38071 3535 54
2215271 2215271 2022-02-14 Ramsey North Dakota 38071 3525 52
2212020 2212020 2022-02-13 Ramsey North Dakota 38071 3521 52
2208767 2208767 2022-02-12 Ramsey North Dakota 38071 3506 52
2205514 2205514 2022-02-11 Ramsey North Dakota 38071 3499 52
2202261 2202261 2022-02-10 Ramsey North Dakota 38071 3485 52
2199007 2199007 2022-02-09 Ramsey North Dakota 38071 3459 52
2195753 2195753 2022-02-08 Ramsey North Dakota 38071 3428 51
2192499 2192499 2022-02-07 Ramsey North Dakota 38071 3408 49
2189245 2189245 2022-02-06 Ramsey North Dakota 38071 3387 49
2185992 2185992 2022-02-05 Ramsey North Dakota 38071 3387 49
2182740 2182740 2022-02-04 Ramsey North Dakota 38071 3371 48
2179488 2179488 2022-02-03 Ramsey North Dakota 38071 3345 48

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