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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
620 | 620 | 2020-03-06 | Ramsey | Minnesota | 27123 | 1 | 0 |
706 | 706 | 2020-03-07 | Ramsey | Minnesota | 27123 | 1 | 0 |
810 | 810 | 2020-03-08 | Ramsey | Minnesota | 27123 | 1 | 0 |
934 | 934 | 2020-03-09 | Ramsey | Minnesota | 27123 | 1 | 0 |
1084 | 1084 | 2020-03-10 | Ramsey | Minnesota | 27123 | 1 | 0 |
1265 | 1265 | 2020-03-11 | Ramsey | Minnesota | 27123 | 2 | 0 |
1490 | 1490 | 2020-03-12 | Ramsey | Minnesota | 27123 | 2 | 0 |
1773 | 1773 | 2020-03-13 | Ramsey | Minnesota | 27123 | 3 | 0 |
2117 | 2117 | 2020-03-14 | Ramsey | Minnesota | 27123 | 4 | 0 |
2521 | 2521 | 2020-03-15 | Ramsey | Minnesota | 27123 | 8 | 0 |
2973 | 2973 | 2020-03-16 | Ramsey | Minnesota | 27123 | 8 | 0 |
3478 | 3478 | 2020-03-17 | Ramsey | Minnesota | 27123 | 8 | 0 |
4061 | 4061 | 2020-03-18 | Ramsey | Minnesota | 27123 | 8 | 0 |
4772 | 4772 | 2020-03-19 | Ramsey | Minnesota | 27123 | 12 | 0 |
5594 | 5594 | 2020-03-20 | Ramsey | Minnesota | 27123 | 16 | 0 |
5785 | 5785 | 2020-03-20 | Ramsey | North Dakota | 38071 | 1 | 0 |
6564 | 6564 | 2020-03-21 | Ramsey | Minnesota | 27123 | 17 | 1 |
6782 | 6782 | 2020-03-21 | Ramsey | North Dakota | 38071 | 1 | 0 |
7646 | 7646 | 2020-03-22 | Ramsey | Minnesota | 27123 | 18 | 1 |
7888 | 7888 | 2020-03-22 | Ramsey | North Dakota | 38071 | 1 | 0 |
8825 | 8825 | 2020-03-23 | Ramsey | Minnesota | 27123 | 24 | 1 |
9090 | 9090 | 2020-03-23 | Ramsey | North Dakota | 38071 | 1 | 0 |
10120 | 10120 | 2020-03-24 | Ramsey | Minnesota | 27123 | 26 | 1 |
10402 | 10402 | 2020-03-24 | Ramsey | North Dakota | 38071 | 1 | 0 |
11538 | 11538 | 2020-03-25 | Ramsey | Minnesota | 27123 | 27 | 1 |
11848 | 11848 | 2020-03-25 | Ramsey | North Dakota | 38071 | 3 | 0 |
13127 | 13127 | 2020-03-26 | Ramsey | Minnesota | 27123 | 32 | 1 |
13454 | 13454 | 2020-03-26 | Ramsey | North Dakota | 38071 | 3 | 0 |
14843 | 14843 | 2020-03-27 | Ramsey | Minnesota | 27123 | 34 | 1 |
15191 | 15191 | 2020-03-27 | Ramsey | North Dakota | 38071 | 3 | 0 |
16665 | 16665 | 2020-03-28 | Ramsey | Minnesota | 27123 | 42 | 2 |
17029 | 17029 | 2020-03-28 | Ramsey | North Dakota | 38071 | 3 | 0 |
18585 | 18585 | 2020-03-29 | Ramsey | Minnesota | 27123 | 46 | 2 |
18963 | 18963 | 2020-03-29 | Ramsey | North Dakota | 38071 | 3 | 0 |
20607 | 20607 | 2020-03-30 | Ramsey | Minnesota | 27123 | 50 | 2 |
21006 | 21006 | 2020-03-30 | Ramsey | North Dakota | 38071 | 3 | 0 |
22722 | 22722 | 2020-03-31 | Ramsey | Minnesota | 27123 | 56 | 2 |
23137 | 23137 | 2020-03-31 | Ramsey | North Dakota | 38071 | 3 | 0 |
24904 | 24904 | 2020-04-01 | Ramsey | Minnesota | 27123 | 66 | 2 |
25332 | 25332 | 2020-04-01 | Ramsey | North Dakota | 38071 | 3 | 0 |
27158 | 27158 | 2020-04-02 | Ramsey | Minnesota | 27123 | 67 | 2 |
27598 | 27598 | 2020-04-02 | Ramsey | North Dakota | 38071 | 3 | 0 |
29477 | 29477 | 2020-04-03 | Ramsey | Minnesota | 27123 | 71 | 2 |
29926 | 29926 | 2020-04-03 | Ramsey | North Dakota | 38071 | 3 | 0 |
31857 | 31857 | 2020-04-04 | Ramsey | Minnesota | 27123 | 79 | 2 |
32314 | 32314 | 2020-04-04 | Ramsey | North Dakota | 38071 | 3 | 0 |
34284 | 34284 | 2020-04-05 | Ramsey | Minnesota | 27123 | 91 | 2 |
34747 | 34747 | 2020-04-05 | Ramsey | North Dakota | 38071 | 3 | 0 |
36745 | 36745 | 2020-04-06 | Ramsey | Minnesota | 27123 | 96 | 3 |
37216 | 37216 | 2020-04-06 | Ramsey | North Dakota | 38071 | 3 | 0 |
39254 | 39254 | 2020-04-07 | Ramsey | Minnesota | 27123 | 101 | 3 |
39733 | 39733 | 2020-04-07 | Ramsey | North Dakota | 38071 | 3 | 0 |
41808 | 41808 | 2020-04-08 | Ramsey | Minnesota | 27123 | 112 | 3 |
42290 | 42290 | 2020-04-08 | Ramsey | North Dakota | 38071 | 3 | 0 |
44384 | 44384 | 2020-04-09 | Ramsey | Minnesota | 27123 | 121 | 5 |
44874 | 44874 | 2020-04-09 | Ramsey | North Dakota | 38071 | 3 | 0 |
46994 | 46994 | 2020-04-10 | Ramsey | Minnesota | 27123 | 124 | 5 |
47487 | 47487 | 2020-04-10 | Ramsey | North Dakota | 38071 | 3 | 0 |
49639 | 49639 | 2020-04-11 | Ramsey | Minnesota | 27123 | 132 | 6 |
50142 | 50142 | 2020-04-11 | Ramsey | North Dakota | 38071 | 3 | 0 |
52309 | 52309 | 2020-04-12 | Ramsey | Minnesota | 27123 | 152 | 6 |
52815 | 52815 | 2020-04-12 | Ramsey | North Dakota | 38071 | 3 | 0 |
54991 | 54991 | 2020-04-13 | Ramsey | Minnesota | 27123 | 152 | 6 |
55499 | 55499 | 2020-04-13 | Ramsey | North Dakota | 38071 | 3 | 0 |
57689 | 57689 | 2020-04-14 | Ramsey | Minnesota | 27123 | 153 | 7 |
58200 | 58200 | 2020-04-14 | Ramsey | North Dakota | 38071 | 3 | 0 |
60400 | 60400 | 2020-04-15 | Ramsey | Minnesota | 27123 | 164 | 7 |
60914 | 60914 | 2020-04-15 | Ramsey | North Dakota | 38071 | 3 | 0 |
63123 | 63123 | 2020-04-16 | Ramsey | Minnesota | 27123 | 177 | 9 |
63640 | 63640 | 2020-04-16 | Ramsey | North Dakota | 38071 | 3 | 0 |
65862 | 65862 | 2020-04-17 | Ramsey | Minnesota | 27123 | 178 | 9 |
66383 | 66383 | 2020-04-17 | Ramsey | North Dakota | 38071 | 3 | 0 |
68614 | 68614 | 2020-04-18 | Ramsey | Minnesota | 27123 | 192 | 9 |
69140 | 69140 | 2020-04-18 | Ramsey | North Dakota | 38071 | 3 | 0 |
71380 | 71380 | 2020-04-19 | Ramsey | Minnesota | 27123 | 196 | 9 |
71907 | 71907 | 2020-04-19 | Ramsey | North Dakota | 38071 | 3 | 0 |
74153 | 74153 | 2020-04-20 | Ramsey | Minnesota | 27123 | 202 | 10 |
74682 | 74682 | 2020-04-20 | Ramsey | North Dakota | 38071 | 3 | 0 |
76934 | 76934 | 2020-04-21 | Ramsey | Minnesota | 27123 | 215 | 11 |
77463 | 77463 | 2020-04-21 | Ramsey | North Dakota | 38071 | 3 | 0 |
79719 | 79719 | 2020-04-22 | Ramsey | Minnesota | 27123 | 219 | 11 |
80252 | 80252 | 2020-04-22 | Ramsey | North Dakota | 38071 | 3 | 0 |
82515 | 82515 | 2020-04-23 | Ramsey | Minnesota | 27123 | 235 | 14 |
83051 | 83051 | 2020-04-23 | Ramsey | North Dakota | 38071 | 3 | 0 |
85319 | 85319 | 2020-04-24 | Ramsey | Minnesota | 27123 | 247 | 18 |
85855 | 85855 | 2020-04-24 | Ramsey | North Dakota | 38071 | 3 | 0 |
88129 | 88129 | 2020-04-25 | Ramsey | Minnesota | 27123 | 261 | 20 |
88669 | 88669 | 2020-04-25 | Ramsey | North Dakota | 38071 | 3 | 0 |
90945 | 90945 | 2020-04-26 | Ramsey | Minnesota | 27123 | 278 | 20 |
91484 | 91484 | 2020-04-26 | Ramsey | North Dakota | 38071 | 3 | 0 |
93766 | 93766 | 2020-04-27 | Ramsey | Minnesota | 27123 | 297 | 22 |
94310 | 94310 | 2020-04-27 | Ramsey | North Dakota | 38071 | 4 | 0 |
96601 | 96601 | 2020-04-28 | Ramsey | Minnesota | 27123 | 317 | 22 |
97147 | 97147 | 2020-04-28 | Ramsey | North Dakota | 38071 | 4 | 0 |
99447 | 99447 | 2020-04-29 | Ramsey | Minnesota | 27123 | 332 | 24 |
99996 | 99996 | 2020-04-29 | Ramsey | North Dakota | 38071 | 3 | 0 |
102299 | 102299 | 2020-04-30 | Ramsey | Minnesota | 27123 | 374 | 26 |
102849 | 102849 | 2020-04-30 | Ramsey | North Dakota | 38071 | 3 | 0 |
105160 | 105160 | 2020-05-01 | Ramsey | Minnesota | 27123 | 405 | 29 |
105711 | 105711 | 2020-05-01 | Ramsey | North Dakota | 38071 | 3 | 0 |
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);