ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,584 rows where county = "Ramsey" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500966 | 2500966 | 2022-05-13 | Ramsey | Minnesota | 27123 | 129009 | 1348 |
2501621 | 2501621 | 2022-05-13 | Ramsey | North Dakota | 38071 | 3638 | 57 |
2497708 | 2497708 | 2022-05-12 | Ramsey | Minnesota | 27123 | 128653 | 1348 |
2498363 | 2498363 | 2022-05-12 | Ramsey | North Dakota | 38071 | 3628 | 57 |
2494450 | 2494450 | 2022-05-11 | Ramsey | Minnesota | 27123 | 128358 | 1346 |
2495105 | 2495105 | 2022-05-11 | Ramsey | North Dakota | 38071 | 3628 | 57 |
2491192 | 2491192 | 2022-05-10 | Ramsey | Minnesota | 27123 | 128183 | 1345 |
2491847 | 2491847 | 2022-05-10 | Ramsey | North Dakota | 38071 | 3628 | 57 |
2487935 | 2487935 | 2022-05-09 | Ramsey | Minnesota | 27123 | 127643 | 1344 |
2488589 | 2488589 | 2022-05-09 | Ramsey | North Dakota | 38071 | 3628 | 57 |
2484677 | 2484677 | 2022-05-08 | Ramsey | Minnesota | 27123 | 127350 | 1343 |
2485332 | 2485332 | 2022-05-08 | Ramsey | North Dakota | 38071 | 3628 | 57 |
2481419 | 2481419 | 2022-05-07 | Ramsey | Minnesota | 27123 | 127350 | 1343 |
2482074 | 2482074 | 2022-05-07 | Ramsey | North Dakota | 38071 | 3628 | 57 |
2478161 | 2478161 | 2022-05-06 | Ramsey | Minnesota | 27123 | 127350 | 1343 |
2478816 | 2478816 | 2022-05-06 | Ramsey | North Dakota | 38071 | 3628 | 57 |
2474903 | 2474903 | 2022-05-05 | Ramsey | Minnesota | 27123 | 127072 | 1341 |
2475558 | 2475558 | 2022-05-05 | Ramsey | North Dakota | 38071 | 3624 | 57 |
2471646 | 2471646 | 2022-05-04 | Ramsey | Minnesota | 27123 | 126823 | 1339 |
2472301 | 2472301 | 2022-05-04 | Ramsey | North Dakota | 38071 | 3624 | 57 |
2468390 | 2468390 | 2022-05-03 | Ramsey | Minnesota | 27123 | 126543 | 1337 |
2469045 | 2469045 | 2022-05-03 | Ramsey | North Dakota | 38071 | 3624 | 57 |
2465135 | 2465135 | 2022-05-02 | Ramsey | Minnesota | 27123 | 126249 | 1337 |
2465789 | 2465789 | 2022-05-02 | Ramsey | North Dakota | 38071 | 3624 | 57 |
2461879 | 2461879 | 2022-05-01 | Ramsey | Minnesota | 27123 | 126091 | 1337 |
2462534 | 2462534 | 2022-05-01 | Ramsey | North Dakota | 38071 | 3624 | 57 |
2458623 | 2458623 | 2022-04-30 | Ramsey | Minnesota | 27123 | 126091 | 1337 |
2459278 | 2459278 | 2022-04-30 | Ramsey | North Dakota | 38071 | 3624 | 57 |
2455367 | 2455367 | 2022-04-29 | Ramsey | Minnesota | 27123 | 126091 | 1337 |
2456022 | 2456022 | 2022-04-29 | Ramsey | North Dakota | 38071 | 3624 | 57 |
2452111 | 2452111 | 2022-04-28 | Ramsey | Minnesota | 27123 | 125906 | 1336 |
2452766 | 2452766 | 2022-04-28 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2448855 | 2448855 | 2022-04-27 | Ramsey | Minnesota | 27123 | 125736 | 1336 |
2449510 | 2449510 | 2022-04-27 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2445599 | 2445599 | 2022-04-26 | Ramsey | Minnesota | 27123 | 125580 | 1336 |
2446253 | 2446253 | 2022-04-26 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2442343 | 2442343 | 2022-04-25 | Ramsey | Minnesota | 27123 | 125305 | 1336 |
2442998 | 2442998 | 2022-04-25 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2439087 | 2439087 | 2022-04-24 | Ramsey | Minnesota | 27123 | 125201 | 1336 |
2439742 | 2439742 | 2022-04-24 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2435831 | 2435831 | 2022-04-23 | Ramsey | Minnesota | 27123 | 125201 | 1336 |
2436486 | 2436486 | 2022-04-23 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2432575 | 2432575 | 2022-04-22 | Ramsey | Minnesota | 27123 | 125201 | 1336 |
2433230 | 2433230 | 2022-04-22 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2429319 | 2429319 | 2022-04-21 | Ramsey | Minnesota | 27123 | 125038 | 1335 |
2429974 | 2429974 | 2022-04-21 | Ramsey | North Dakota | 38071 | 3618 | 57 |
2426063 | 2426063 | 2022-04-20 | Ramsey | Minnesota | 27123 | 124947 | 1335 |
2426718 | 2426718 | 2022-04-20 | Ramsey | North Dakota | 38071 | 3618 | 57 |
2422807 | 2422807 | 2022-04-19 | Ramsey | Minnesota | 27123 | 124862 | 1335 |
2423462 | 2423462 | 2022-04-19 | Ramsey | North Dakota | 38071 | 3618 | 57 |
2419551 | 2419551 | 2022-04-18 | Ramsey | Minnesota | 27123 | 124674 | 1333 |
2420205 | 2420205 | 2022-04-18 | Ramsey | North Dakota | 38071 | 3618 | 57 |
2416295 | 2416295 | 2022-04-17 | Ramsey | Minnesota | 27123 | 124568 | 1333 |
2416950 | 2416950 | 2022-04-17 | Ramsey | North Dakota | 38071 | 3618 | 57 |
2413039 | 2413039 | 2022-04-16 | Ramsey | Minnesota | 27123 | 124568 | 1333 |
2413694 | 2413694 | 2022-04-16 | Ramsey | North Dakota | 38071 | 3618 | 57 |
2409783 | 2409783 | 2022-04-15 | Ramsey | Minnesota | 27123 | 124568 | 1333 |
2410438 | 2410438 | 2022-04-15 | Ramsey | North Dakota | 38071 | 3618 | 57 |
2406527 | 2406527 | 2022-04-14 | Ramsey | Minnesota | 27123 | 124464 | 1332 |
2407182 | 2407182 | 2022-04-14 | Ramsey | North Dakota | 38071 | 3611 | 57 |
2403271 | 2403271 | 2022-04-13 | Ramsey | Minnesota | 27123 | 124381 | 1332 |
2403926 | 2403926 | 2022-04-13 | Ramsey | North Dakota | 38071 | 3611 | 57 |
2400017 | 2400017 | 2022-04-12 | Ramsey | Minnesota | 27123 | 124284 | 1332 |
2400671 | 2400671 | 2022-04-12 | Ramsey | North Dakota | 38071 | 3611 | 57 |
2396761 | 2396761 | 2022-04-11 | Ramsey | Minnesota | 27123 | 124152 | 1332 |
2397416 | 2397416 | 2022-04-11 | Ramsey | North Dakota | 38071 | 3611 | 57 |
2393506 | 2393506 | 2022-04-10 | Ramsey | Minnesota | 27123 | 124064 | 1331 |
2394161 | 2394161 | 2022-04-10 | Ramsey | North Dakota | 38071 | 3611 | 57 |
2390250 | 2390250 | 2022-04-09 | Ramsey | Minnesota | 27123 | 124064 | 1331 |
2390905 | 2390905 | 2022-04-09 | Ramsey | North Dakota | 38071 | 3611 | 57 |
2386994 | 2386994 | 2022-04-08 | Ramsey | Minnesota | 27123 | 124064 | 1331 |
2387649 | 2387649 | 2022-04-08 | Ramsey | North Dakota | 38071 | 3611 | 57 |
2383739 | 2383739 | 2022-04-07 | Ramsey | Minnesota | 27123 | 124009 | 1330 |
2384394 | 2384394 | 2022-04-07 | Ramsey | North Dakota | 38071 | 3608 | 57 |
2380484 | 2380484 | 2022-04-06 | Ramsey | Minnesota | 27123 | 123950 | 1329 |
2381139 | 2381139 | 2022-04-06 | Ramsey | North Dakota | 38071 | 3608 | 57 |
2377229 | 2377229 | 2022-04-05 | Ramsey | Minnesota | 27123 | 123917 | 1328 |
2377884 | 2377884 | 2022-04-05 | Ramsey | North Dakota | 38071 | 3608 | 57 |
2373977 | 2373977 | 2022-04-04 | Ramsey | Minnesota | 27123 | 123821 | 1328 |
2374631 | 2374631 | 2022-04-04 | Ramsey | North Dakota | 38071 | 3608 | 57 |
2370724 | 2370724 | 2022-04-03 | Ramsey | Minnesota | 27123 | 123765 | 1328 |
2371379 | 2371379 | 2022-04-03 | Ramsey | North Dakota | 38071 | 3608 | 57 |
2367471 | 2367471 | 2022-04-02 | Ramsey | Minnesota | 27123 | 123765 | 1328 |
2368126 | 2368126 | 2022-04-02 | Ramsey | North Dakota | 38071 | 3608 | 57 |
2364218 | 2364218 | 2022-04-01 | Ramsey | Minnesota | 27123 | 123765 | 1328 |
2364873 | 2364873 | 2022-04-01 | Ramsey | North Dakota | 38071 | 3608 | 57 |
2360964 | 2360964 | 2022-03-31 | Ramsey | Minnesota | 27123 | 123713 | 1328 |
2361619 | 2361619 | 2022-03-31 | Ramsey | North Dakota | 38071 | 3607 | 57 |
2357710 | 2357710 | 2022-03-30 | Ramsey | Minnesota | 27123 | 123665 | 1328 |
2358365 | 2358365 | 2022-03-30 | Ramsey | North Dakota | 38071 | 3607 | 57 |
2354457 | 2354457 | 2022-03-29 | Ramsey | Minnesota | 27123 | 123630 | 1327 |
2355111 | 2355111 | 2022-03-29 | Ramsey | North Dakota | 38071 | 3607 | 57 |
2351205 | 2351205 | 2022-03-28 | Ramsey | Minnesota | 27123 | 123509 | 1327 |
2351858 | 2351858 | 2022-03-28 | Ramsey | North Dakota | 38071 | 3607 | 57 |
2347952 | 2347952 | 2022-03-27 | Ramsey | Minnesota | 27123 | 123468 | 1325 |
2348606 | 2348606 | 2022-03-27 | Ramsey | North Dakota | 38071 | 3607 | 57 |
2344699 | 2344699 | 2022-03-26 | Ramsey | Minnesota | 27123 | 123468 | 1325 |
2345353 | 2345353 | 2022-03-26 | Ramsey | North Dakota | 38071 | 3607 | 57 |
2341446 | 2341446 | 2022-03-25 | Ramsey | Minnesota | 27123 | 123468 | 1325 |
2342100 | 2342100 | 2022-03-25 | Ramsey | North Dakota | 38071 | 3607 | 57 |
Advanced export
JSON shape: default, array, newline-delimited
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);