ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 27123 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, 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 |
6564 | 6564 | 2020-03-21 | Ramsey | Minnesota | 27123 | 17 | 1 |
7646 | 7646 | 2020-03-22 | Ramsey | Minnesota | 27123 | 18 | 1 |
8825 | 8825 | 2020-03-23 | Ramsey | Minnesota | 27123 | 24 | 1 |
10120 | 10120 | 2020-03-24 | Ramsey | Minnesota | 27123 | 26 | 1 |
11538 | 11538 | 2020-03-25 | Ramsey | Minnesota | 27123 | 27 | 1 |
13127 | 13127 | 2020-03-26 | Ramsey | Minnesota | 27123 | 32 | 1 |
14843 | 14843 | 2020-03-27 | Ramsey | Minnesota | 27123 | 34 | 1 |
16665 | 16665 | 2020-03-28 | Ramsey | Minnesota | 27123 | 42 | 2 |
18585 | 18585 | 2020-03-29 | Ramsey | Minnesota | 27123 | 46 | 2 |
20607 | 20607 | 2020-03-30 | Ramsey | Minnesota | 27123 | 50 | 2 |
22722 | 22722 | 2020-03-31 | Ramsey | Minnesota | 27123 | 56 | 2 |
24904 | 24904 | 2020-04-01 | Ramsey | Minnesota | 27123 | 66 | 2 |
27158 | 27158 | 2020-04-02 | Ramsey | Minnesota | 27123 | 67 | 2 |
29477 | 29477 | 2020-04-03 | Ramsey | Minnesota | 27123 | 71 | 2 |
31857 | 31857 | 2020-04-04 | Ramsey | Minnesota | 27123 | 79 | 2 |
34284 | 34284 | 2020-04-05 | Ramsey | Minnesota | 27123 | 91 | 2 |
36745 | 36745 | 2020-04-06 | Ramsey | Minnesota | 27123 | 96 | 3 |
39254 | 39254 | 2020-04-07 | Ramsey | Minnesota | 27123 | 101 | 3 |
41808 | 41808 | 2020-04-08 | Ramsey | Minnesota | 27123 | 112 | 3 |
44384 | 44384 | 2020-04-09 | Ramsey | Minnesota | 27123 | 121 | 5 |
46994 | 46994 | 2020-04-10 | Ramsey | Minnesota | 27123 | 124 | 5 |
49639 | 49639 | 2020-04-11 | Ramsey | Minnesota | 27123 | 132 | 6 |
52309 | 52309 | 2020-04-12 | Ramsey | Minnesota | 27123 | 152 | 6 |
54991 | 54991 | 2020-04-13 | Ramsey | Minnesota | 27123 | 152 | 6 |
57689 | 57689 | 2020-04-14 | Ramsey | Minnesota | 27123 | 153 | 7 |
60400 | 60400 | 2020-04-15 | Ramsey | Minnesota | 27123 | 164 | 7 |
63123 | 63123 | 2020-04-16 | Ramsey | Minnesota | 27123 | 177 | 9 |
65862 | 65862 | 2020-04-17 | Ramsey | Minnesota | 27123 | 178 | 9 |
68614 | 68614 | 2020-04-18 | Ramsey | Minnesota | 27123 | 192 | 9 |
71380 | 71380 | 2020-04-19 | Ramsey | Minnesota | 27123 | 196 | 9 |
74153 | 74153 | 2020-04-20 | Ramsey | Minnesota | 27123 | 202 | 10 |
76934 | 76934 | 2020-04-21 | Ramsey | Minnesota | 27123 | 215 | 11 |
79719 | 79719 | 2020-04-22 | Ramsey | Minnesota | 27123 | 219 | 11 |
82515 | 82515 | 2020-04-23 | Ramsey | Minnesota | 27123 | 235 | 14 |
85319 | 85319 | 2020-04-24 | Ramsey | Minnesota | 27123 | 247 | 18 |
88129 | 88129 | 2020-04-25 | Ramsey | Minnesota | 27123 | 261 | 20 |
90945 | 90945 | 2020-04-26 | Ramsey | Minnesota | 27123 | 278 | 20 |
93766 | 93766 | 2020-04-27 | Ramsey | Minnesota | 27123 | 297 | 22 |
96601 | 96601 | 2020-04-28 | Ramsey | Minnesota | 27123 | 317 | 22 |
99447 | 99447 | 2020-04-29 | Ramsey | Minnesota | 27123 | 332 | 24 |
102299 | 102299 | 2020-04-30 | Ramsey | Minnesota | 27123 | 374 | 26 |
105160 | 105160 | 2020-05-01 | Ramsey | Minnesota | 27123 | 405 | 29 |
108025 | 108025 | 2020-05-02 | Ramsey | Minnesota | 27123 | 453 | 31 |
110896 | 110896 | 2020-05-03 | Ramsey | Minnesota | 27123 | 493 | 34 |
113775 | 113775 | 2020-05-04 | Ramsey | Minnesota | 27123 | 535 | 34 |
116657 | 116657 | 2020-05-05 | Ramsey | Minnesota | 27123 | 583 | 37 |
119617 | 119617 | 2020-05-06 | Ramsey | Minnesota | 27123 | 656 | 38 |
122591 | 122591 | 2020-05-07 | Ramsey | Minnesota | 27123 | 717 | 39 |
125573 | 125573 | 2020-05-08 | Ramsey | Minnesota | 27123 | 800 | 42 |
128560 | 128560 | 2020-05-09 | Ramsey | Minnesota | 27123 | 875 | 43 |
131550 | 131550 | 2020-05-10 | Ramsey | Minnesota | 27123 | 920 | 45 |
134541 | 134541 | 2020-05-11 | Ramsey | Minnesota | 27123 | 986 | 47 |
137531 | 137531 | 2020-05-12 | Ramsey | Minnesota | 27123 | 1052 | 49 |
140525 | 140525 | 2020-05-13 | Ramsey | Minnesota | 27123 | 1052 | 49 |
143520 | 143520 | 2020-05-14 | Ramsey | Minnesota | 27123 | 1167 | 56 |
146520 | 146520 | 2020-05-15 | Ramsey | Minnesota | 27123 | 1287 | 61 |
149525 | 149525 | 2020-05-16 | Ramsey | Minnesota | 27123 | 1416 | 67 |
152536 | 152536 | 2020-05-17 | Ramsey | Minnesota | 27123 | 1530 | 71 |
155550 | 155550 | 2020-05-18 | Ramsey | Minnesota | 27123 | 1625 | 72 |
158568 | 158568 | 2020-05-19 | Ramsey | Minnesota | 27123 | 1720 | 74 |
161594 | 161594 | 2020-05-20 | Ramsey | Minnesota | 27123 | 1846 | 80 |
164623 | 164623 | 2020-05-21 | Ramsey | Minnesota | 27123 | 1925 | 86 |
167659 | 167659 | 2020-05-22 | Ramsey | Minnesota | 27123 | 2018 | 93 |
170697 | 170697 | 2020-05-23 | Ramsey | Minnesota | 27123 | 2164 | 94 |
173739 | 173739 | 2020-05-24 | Ramsey | Minnesota | 27123 | 2316 | 97 |
176782 | 176782 | 2020-05-25 | Ramsey | Minnesota | 27123 | 2437 | 97 |
179826 | 179826 | 2020-05-26 | Ramsey | Minnesota | 27123 | 2551 | 98 |
182872 | 182872 | 2020-05-27 | Ramsey | Minnesota | 27123 | 2610 | 103 |
185927 | 185927 | 2020-05-28 | Ramsey | Minnesota | 27123 | 2698 | 110 |
188985 | 188985 | 2020-05-29 | Ramsey | Minnesota | 27123 | 2790 | 115 |
192049 | 192049 | 2020-05-30 | Ramsey | Minnesota | 27123 | 2863 | 122 |
195117 | 195117 | 2020-05-31 | Ramsey | Minnesota | 27123 | 3019 | 124 |
198188 | 198188 | 2020-06-01 | Ramsey | Minnesota | 27123 | 3075 | 128 |
201261 | 201261 | 2020-06-02 | Ramsey | Minnesota | 27123 | 3128 | 133 |
204338 | 204338 | 2020-06-03 | Ramsey | Minnesota | 27123 | 3189 | 134 |
207419 | 207419 | 2020-06-04 | Ramsey | Minnesota | 27123 | 3252 | 140 |
210500 | 210500 | 2020-06-05 | Ramsey | Minnesota | 27123 | 3351 | 149 |
213584 | 213584 | 2020-06-06 | Ramsey | Minnesota | 27123 | 3445 | 152 |
216672 | 216672 | 2020-06-07 | Ramsey | Minnesota | 27123 | 3507 | 155 |
219764 | 219764 | 2020-06-08 | Ramsey | Minnesota | 27123 | 3553 | 158 |
222859 | 222859 | 2020-06-09 | Ramsey | Minnesota | 27123 | 3626 | 164 |
225957 | 225957 | 2020-06-10 | Ramsey | Minnesota | 27123 | 3680 | 167 |
229059 | 229059 | 2020-06-11 | Ramsey | Minnesota | 27123 | 3740 | 169 |
232163 | 232163 | 2020-06-12 | Ramsey | Minnesota | 27123 | 3813 | 180 |
235269 | 235269 | 2020-06-13 | Ramsey | Minnesota | 27123 | 3882 | 182 |
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);