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)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338193 | 2338193 | 2022-03-24 | Ramsey | Minnesota | 27123 | 123409 | 1325 |
2338847 | 2338847 | 2022-03-24 | Ramsey | North Dakota | 38071 | 3606 | 57 |
2334939 | 2334939 | 2022-03-23 | Ramsey | Minnesota | 27123 | 123376 | 1323 |
2335593 | 2335593 | 2022-03-23 | Ramsey | North Dakota | 38071 | 3606 | 57 |
2331685 | 2331685 | 2022-03-22 | Ramsey | Minnesota | 27123 | 123348 | 1323 |
2332339 | 2332339 | 2022-03-22 | Ramsey | North Dakota | 38071 | 3606 | 57 |
2328433 | 2328433 | 2022-03-21 | Ramsey | Minnesota | 27123 | 123237 | 1322 |
2329086 | 2329086 | 2022-03-21 | Ramsey | North Dakota | 38071 | 3606 | 57 |
2325180 | 2325180 | 2022-03-20 | Ramsey | Minnesota | 27123 | 123204 | 1322 |
2325834 | 2325834 | 2022-03-20 | Ramsey | North Dakota | 38071 | 3606 | 57 |
2321926 | 2321926 | 2022-03-19 | Ramsey | Minnesota | 27123 | 123204 | 1322 |
2322581 | 2322581 | 2022-03-19 | Ramsey | North Dakota | 38071 | 3606 | 57 |
2318672 | 2318672 | 2022-03-18 | Ramsey | Minnesota | 27123 | 123204 | 1322 |
2319327 | 2319327 | 2022-03-18 | Ramsey | North Dakota | 38071 | 3606 | 57 |
2315419 | 2315419 | 2022-03-17 | Ramsey | Minnesota | 27123 | 123165 | 1322 |
2316073 | 2316073 | 2022-03-17 | Ramsey | North Dakota | 38071 | 3605 | 57 |
2312166 | 2312166 | 2022-03-16 | Ramsey | Minnesota | 27123 | 123128 | 1322 |
2312820 | 2312820 | 2022-03-16 | Ramsey | North Dakota | 38071 | 3605 | 57 |
2308913 | 2308913 | 2022-03-15 | Ramsey | Minnesota | 27123 | 123037 | 1320 |
2309567 | 2309567 | 2022-03-15 | Ramsey | North Dakota | 38071 | 3605 | 57 |
2305662 | 2305662 | 2022-03-14 | Ramsey | Minnesota | 27123 | 122969 | 1320 |
2306314 | 2306314 | 2022-03-14 | Ramsey | North Dakota | 38071 | 3605 | 57 |
2302410 | 2302410 | 2022-03-13 | Ramsey | Minnesota | 27123 | 122914 | 1317 |
2303063 | 2303063 | 2022-03-13 | Ramsey | North Dakota | 38071 | 3605 | 57 |
2299158 | 2299158 | 2022-03-12 | Ramsey | Minnesota | 27123 | 122914 | 1317 |
2299811 | 2299811 | 2022-03-12 | Ramsey | North Dakota | 38071 | 3605 | 57 |
2295906 | 2295906 | 2022-03-11 | Ramsey | Minnesota | 27123 | 122914 | 1317 |
2296559 | 2296559 | 2022-03-11 | Ramsey | North Dakota | 38071 | 3607 | 56 |
2292654 | 2292654 | 2022-03-10 | Ramsey | Minnesota | 27123 | 122685 | 1317 |
2293307 | 2293307 | 2022-03-10 | Ramsey | North Dakota | 38071 | 3610 | 56 |
2289402 | 2289402 | 2022-03-09 | Ramsey | Minnesota | 27123 | 122613 | 1313 |
2290055 | 2290055 | 2022-03-09 | Ramsey | North Dakota | 38071 | 3611 | 56 |
2286151 | 2286151 | 2022-03-08 | Ramsey | Minnesota | 27123 | 122564 | 1313 |
2286803 | 2286803 | 2022-03-08 | Ramsey | North Dakota | 38071 | 3613 | 55 |
2282899 | 2282899 | 2022-03-07 | Ramsey | Minnesota | 27123 | 122419 | 1310 |
2283551 | 2283551 | 2022-03-07 | Ramsey | North Dakota | 38071 | 3613 | 55 |
2279646 | 2279646 | 2022-03-06 | Ramsey | Minnesota | 27123 | 122308 | 1308 |
2280299 | 2280299 | 2022-03-06 | Ramsey | North Dakota | 38071 | 3613 | 55 |
2276393 | 2276393 | 2022-03-05 | Ramsey | Minnesota | 27123 | 122308 | 1308 |
2277046 | 2277046 | 2022-03-05 | Ramsey | North Dakota | 38071 | 3613 | 55 |
2273140 | 2273140 | 2022-03-04 | Ramsey | Minnesota | 27123 | 122308 | 1308 |
2273793 | 2273793 | 2022-03-04 | Ramsey | North Dakota | 38071 | 3610 | 55 |
2269888 | 2269888 | 2022-03-03 | Ramsey | Minnesota | 27123 | 122235 | 1305 |
2270540 | 2270540 | 2022-03-03 | Ramsey | North Dakota | 38071 | 3608 | 55 |
2266635 | 2266635 | 2022-03-02 | Ramsey | Minnesota | 27123 | 122174 | 1305 |
2267288 | 2267288 | 2022-03-02 | Ramsey | North Dakota | 38071 | 3605 | 55 |
2263384 | 2263384 | 2022-03-01 | Ramsey | Minnesota | 27123 | 121952 | 1303 |
2264036 | 2264036 | 2022-03-01 | Ramsey | North Dakota | 38071 | 3600 | 55 |
2260133 | 2260133 | 2022-02-28 | Ramsey | Minnesota | 27123 | 121779 | 1302 |
2260785 | 2260785 | 2022-02-28 | Ramsey | North Dakota | 38071 | 3599 | 55 |
2256882 | 2256882 | 2022-02-27 | Ramsey | Minnesota | 27123 | 121714 | 1301 |
2257534 | 2257534 | 2022-02-27 | Ramsey | North Dakota | 38071 | 3599 | 55 |
2253631 | 2253631 | 2022-02-26 | Ramsey | Minnesota | 27123 | 121714 | 1301 |
2254283 | 2254283 | 2022-02-26 | Ramsey | North Dakota | 38071 | 3597 | 55 |
2250380 | 2250380 | 2022-02-25 | Ramsey | Minnesota | 27123 | 121714 | 1301 |
2251032 | 2251032 | 2022-02-25 | Ramsey | North Dakota | 38071 | 3597 | 55 |
2247129 | 2247129 | 2022-02-24 | Ramsey | Minnesota | 27123 | 121634 | 1301 |
2247781 | 2247781 | 2022-02-24 | Ramsey | North Dakota | 38071 | 3594 | 55 |
2243878 | 2243878 | 2022-02-23 | Ramsey | Minnesota | 27123 | 121524 | 1300 |
2244530 | 2244530 | 2022-02-23 | Ramsey | North Dakota | 38071 | 3586 | 54 |
2240627 | 2240627 | 2022-02-22 | Ramsey | Minnesota | 27123 | 121407 | 1298 |
2241279 | 2241279 | 2022-02-22 | Ramsey | North Dakota | 38071 | 3581 | 54 |
2237376 | 2237376 | 2022-02-21 | Ramsey | Minnesota | 27123 | 121272 | 1293 |
2238028 | 2238028 | 2022-02-21 | Ramsey | North Dakota | 38071 | 3582 | 54 |
2234125 | 2234125 | 2022-02-20 | Ramsey | Minnesota | 27123 | 121272 | 1293 |
2234777 | 2234777 | 2022-02-20 | Ramsey | North Dakota | 38071 | 3578 | 54 |
2230874 | 2230874 | 2022-02-19 | Ramsey | Minnesota | 27123 | 121272 | 1293 |
2231526 | 2231526 | 2022-02-19 | Ramsey | North Dakota | 38071 | 3577 | 54 |
2227623 | 2227623 | 2022-02-18 | Ramsey | Minnesota | 27123 | 121272 | 1293 |
2228275 | 2228275 | 2022-02-18 | Ramsey | North Dakota | 38071 | 3567 | 54 |
2224372 | 2224372 | 2022-02-17 | Ramsey | Minnesota | 27123 | 120786 | 1291 |
2225024 | 2225024 | 2022-02-17 | Ramsey | North Dakota | 38071 | 3563 | 54 |
2221121 | 2221121 | 2022-02-16 | Ramsey | Minnesota | 27123 | 120705 | 1287 |
2221773 | 2221773 | 2022-02-16 | Ramsey | North Dakota | 38071 | 3547 | 54 |
2217870 | 2217870 | 2022-02-15 | Ramsey | Minnesota | 27123 | 120608 | 1280 |
2218522 | 2218522 | 2022-02-15 | Ramsey | North Dakota | 38071 | 3535 | 54 |
2214619 | 2214619 | 2022-02-14 | Ramsey | Minnesota | 27123 | 120332 | 1279 |
2215271 | 2215271 | 2022-02-14 | Ramsey | North Dakota | 38071 | 3525 | 52 |
2211367 | 2211367 | 2022-02-13 | Ramsey | Minnesota | 27123 | 119883 | 1278 |
2212020 | 2212020 | 2022-02-13 | Ramsey | North Dakota | 38071 | 3521 | 52 |
2208114 | 2208114 | 2022-02-12 | Ramsey | Minnesota | 27123 | 119883 | 1278 |
2208767 | 2208767 | 2022-02-12 | Ramsey | North Dakota | 38071 | 3506 | 52 |
2204861 | 2204861 | 2022-02-11 | Ramsey | Minnesota | 27123 | 119883 | 1278 |
2205514 | 2205514 | 2022-02-11 | Ramsey | North Dakota | 38071 | 3499 | 52 |
2201608 | 2201608 | 2022-02-10 | Ramsey | Minnesota | 27123 | 119634 | 1275 |
2202261 | 2202261 | 2022-02-10 | Ramsey | North Dakota | 38071 | 3485 | 52 |
2198354 | 2198354 | 2022-02-09 | Ramsey | Minnesota | 27123 | 119258 | 1269 |
2199007 | 2199007 | 2022-02-09 | Ramsey | North Dakota | 38071 | 3459 | 52 |
2195100 | 2195100 | 2022-02-08 | Ramsey | Minnesota | 27123 | 118777 | 1265 |
2195753 | 2195753 | 2022-02-08 | Ramsey | North Dakota | 38071 | 3428 | 51 |
2191846 | 2191846 | 2022-02-07 | Ramsey | Minnesota | 27123 | 118073 | 1263 |
2192499 | 2192499 | 2022-02-07 | Ramsey | North Dakota | 38071 | 3408 | 49 |
2188593 | 2188593 | 2022-02-06 | Ramsey | Minnesota | 27123 | 117587 | 1258 |
2189245 | 2189245 | 2022-02-06 | Ramsey | North Dakota | 38071 | 3387 | 49 |
2185340 | 2185340 | 2022-02-05 | Ramsey | Minnesota | 27123 | 117587 | 1258 |
2185992 | 2185992 | 2022-02-05 | Ramsey | North Dakota | 38071 | 3387 | 49 |
2182088 | 2182088 | 2022-02-04 | Ramsey | Minnesota | 27123 | 117587 | 1258 |
2182740 | 2182740 | 2022-02-04 | Ramsey | North Dakota | 38071 | 3371 | 48 |
2178836 | 2178836 | 2022-02-03 | Ramsey | Minnesota | 27123 | 117123 | 1257 |
2179488 | 2179488 | 2022-02-03 | Ramsey | North Dakota | 38071 | 3345 | 48 |
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);