ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Pearl River" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 184 ✖
- 275 54
- 244 42
- 32 37
- 146 36
- 148 24
- 0 22
- 31 21
- 237 14
- 248 12
- 48 11
- 49 11
- 54 11
- 132 11
- 53 10
- 60 10
- 139 10
- 149 10
- 245 10
- 142 9
- 67 8
- 133 8
- 27 7
- 145 7
- 147 7
- 240 7
- 241 7
- 272 7
- 73 6
- 137 6
- 243 6
- 262 6
- 269 6
- 8 5
- 10 5
- 20 5
- 24 5
- 26 5
- 50 5
- 62 5
- 79 5
- 160 5
- 236 5
- 242 5
- 34 4
- 36 4
- 37 4
- 40 4
- 45 4
- 64 4
- 65 4
- 117 4
- 123 4
- 126 4
- 127 4
- 141 4
- 143 4
- 152 4
- 185 4
- 221 4
- 246 4
- 268 4
- 14 3
- 35 3
- 55 3
- 56 3
- 59 3
- 66 3
- 68 3
- 71 3
- 75 3
- 77 3
- 80 3
- 89 3
- 106 3
- 128 3
- 130 3
- 144 3
- 156 3
- 169 3
- 178 3
- 196 3
- 209 3
- 230 3
- 238 3
- 250 3
- 251 3
- 259 3
- 265 3
- 266 3
- 1 2
- 3 2
- 4 2
- 25 2
- 39 2
- 41 2
- 42 2
- 44 2
- 61 2
- 70 2
- 72 2
- 81 2
- 82 2
- 87 2
- 91 2
- 99 2
- 105 2
- 109 2
- 111 2
- 121 2
- 138 2
- 150 2
- 155 2
- 158 2
- 166 2
- 174 2
- 187 2
- 208 2
- 229 2
- 235 2
- 258 2
- 261 2
- 263 2
- 2 1
- 6 1
- 7 1
- 11 1
- 13 1
- 15 1
- 18 1
- 19 1
- 21 1
- 30 1
- 38 1
- 46 1
- 52 1
- 58 1
- 69 1
- 74 1
- 83 1
- 85 1
- 88 1
- 90 1
- 92 1
- 95 1
- 100 1
- 103 1
- 104 1
- 107 1
- 110 1
- 113 1
- 115 1
- 116 1
- 122 1
- 129 1
- 131 1
- 134 1
- 135 1
- 136 1
- 151 1
- 153 1
- 154 1
- 165 1
- 167 1
- 170 1
- 175 1
- 179 1
- 180 1
- 183 1
- 191 1
- 197 1
- 199 1
- 203 1
- 213 1
- 216 1
- 217 1
- 219 1
- 226 1
- 231 1
- 247 1
- 249 1
- 253 1
- 256 1
- 260 1
- 267 1
state 1
- Mississippi 792
fips 1
- 28109 792
county 1
- Pearl River · 792 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1779 | 1779 | 2020-03-13 | Pearl River | Mississippi | 28109 | 1 | 0 |
2124 | 2124 | 2020-03-14 | Pearl River | Mississippi | 28109 | 1 | 0 |
2531 | 2531 | 2020-03-15 | Pearl River | Mississippi | 28109 | 2 | 0 |
2985 | 2985 | 2020-03-16 | Pearl River | Mississippi | 28109 | 2 | 0 |
3492 | 3492 | 2020-03-17 | Pearl River | Mississippi | 28109 | 2 | 0 |
4080 | 4080 | 2020-03-18 | Pearl River | Mississippi | 28109 | 4 | 0 |
4794 | 4794 | 2020-03-19 | Pearl River | Mississippi | 28109 | 7 | 0 |
5623 | 5623 | 2020-03-20 | Pearl River | Mississippi | 28109 | 7 | 0 |
6606 | 6606 | 2020-03-21 | Pearl River | Mississippi | 28109 | 9 | 0 |
7691 | 7691 | 2020-03-22 | Pearl River | Mississippi | 28109 | 10 | 0 |
8873 | 8873 | 2020-03-23 | Pearl River | Mississippi | 28109 | 12 | 0 |
10171 | 10171 | 2020-03-24 | Pearl River | Mississippi | 28109 | 13 | 0 |
11591 | 11591 | 2020-03-25 | Pearl River | Mississippi | 28109 | 13 | 0 |
13184 | 13184 | 2020-03-26 | Pearl River | Mississippi | 28109 | 16 | 0 |
14903 | 14903 | 2020-03-27 | Pearl River | Mississippi | 28109 | 18 | 0 |
16727 | 16727 | 2020-03-28 | Pearl River | Mississippi | 28109 | 23 | 0 |
18649 | 18649 | 2020-03-29 | Pearl River | Mississippi | 28109 | 27 | 0 |
20673 | 20673 | 2020-03-30 | Pearl River | Mississippi | 28109 | 27 | 0 |
22790 | 22790 | 2020-03-31 | Pearl River | Mississippi | 28109 | 30 | 0 |
24974 | 24974 | 2020-04-01 | Pearl River | Mississippi | 28109 | 32 | 0 |
27228 | 27228 | 2020-04-02 | Pearl River | Mississippi | 28109 | 36 | 0 |
29547 | 29547 | 2020-04-03 | Pearl River | Mississippi | 28109 | 41 | 0 |
31927 | 31927 | 2020-04-04 | Pearl River | Mississippi | 28109 | 43 | 1 |
34354 | 34354 | 2020-04-05 | Pearl River | Mississippi | 28109 | 49 | 1 |
36817 | 36817 | 2020-04-06 | Pearl River | Mississippi | 28109 | 52 | 2 |
39328 | 39328 | 2020-04-07 | Pearl River | Mississippi | 28109 | 56 | 3 |
41882 | 41882 | 2020-04-08 | Pearl River | Mississippi | 28109 | 60 | 3 |
44459 | 44459 | 2020-04-09 | Pearl River | Mississippi | 28109 | 73 | 4 |
47068 | 47068 | 2020-04-10 | Pearl River | Mississippi | 28109 | 77 | 4 |
49714 | 49714 | 2020-04-11 | Pearl River | Mississippi | 28109 | 82 | 6 |
52387 | 52387 | 2020-04-12 | Pearl River | Mississippi | 28109 | 83 | 7 |
55069 | 55069 | 2020-04-13 | Pearl River | Mississippi | 28109 | 88 | 8 |
57767 | 57767 | 2020-04-14 | Pearl River | Mississippi | 28109 | 93 | 8 |
60478 | 60478 | 2020-04-15 | Pearl River | Mississippi | 28109 | 102 | 8 |
63200 | 63200 | 2020-04-16 | Pearl River | Mississippi | 28109 | 112 | 8 |
65940 | 65940 | 2020-04-17 | Pearl River | Mississippi | 28109 | 115 | 8 |
68692 | 68692 | 2020-04-18 | Pearl River | Mississippi | 28109 | 119 | 10 |
71458 | 71458 | 2020-04-19 | Pearl River | Mississippi | 28109 | 126 | 10 |
74231 | 74231 | 2020-04-20 | Pearl River | Mississippi | 28109 | 132 | 10 |
77012 | 77012 | 2020-04-21 | Pearl River | Mississippi | 28109 | 134 | 10 |
79797 | 79797 | 2020-04-22 | Pearl River | Mississippi | 28109 | 136 | 10 |
82593 | 82593 | 2020-04-23 | Pearl River | Mississippi | 28109 | 142 | 11 |
85397 | 85397 | 2020-04-24 | Pearl River | Mississippi | 28109 | 144 | 13 |
88207 | 88207 | 2020-04-25 | Pearl River | Mississippi | 28109 | 148 | 14 |
91023 | 91023 | 2020-04-26 | Pearl River | Mississippi | 28109 | 152 | 14 |
93844 | 93844 | 2020-04-27 | Pearl River | Mississippi | 28109 | 153 | 14 |
96680 | 96680 | 2020-04-28 | Pearl River | Mississippi | 28109 | 154 | 15 |
99526 | 99526 | 2020-04-29 | Pearl River | Mississippi | 28109 | 157 | 18 |
102378 | 102378 | 2020-04-30 | Pearl River | Mississippi | 28109 | 163 | 19 |
105239 | 105239 | 2020-05-01 | Pearl River | Mississippi | 28109 | 175 | 20 |
108104 | 108104 | 2020-05-02 | Pearl River | Mississippi | 28109 | 176 | 20 |
110975 | 110975 | 2020-05-03 | Pearl River | Mississippi | 28109 | 177 | 20 |
113854 | 113854 | 2020-05-04 | Pearl River | Mississippi | 28109 | 181 | 20 |
116736 | 116736 | 2020-05-05 | Pearl River | Mississippi | 28109 | 183 | 20 |
119696 | 119696 | 2020-05-06 | Pearl River | Mississippi | 28109 | 183 | 21 |
122670 | 122670 | 2020-05-07 | Pearl River | Mississippi | 28109 | 188 | 24 |
125652 | 125652 | 2020-05-08 | Pearl River | Mississippi | 28109 | 189 | 24 |
128639 | 128639 | 2020-05-09 | Pearl River | Mississippi | 28109 | 190 | 24 |
131629 | 131629 | 2020-05-10 | Pearl River | Mississippi | 28109 | 189 | 24 |
134620 | 134620 | 2020-05-11 | Pearl River | Mississippi | 28109 | 190 | 24 |
137610 | 137610 | 2020-05-12 | Pearl River | Mississippi | 28109 | 190 | 25 |
140604 | 140604 | 2020-05-13 | Pearl River | Mississippi | 28109 | 190 | 25 |
143599 | 143599 | 2020-05-14 | Pearl River | Mississippi | 28109 | 193 | 26 |
146599 | 146599 | 2020-05-15 | Pearl River | Mississippi | 28109 | 195 | 26 |
149604 | 149604 | 2020-05-16 | Pearl River | Mississippi | 28109 | 195 | 26 |
152615 | 152615 | 2020-05-17 | Pearl River | Mississippi | 28109 | 195 | 26 |
155629 | 155629 | 2020-05-18 | Pearl River | Mississippi | 28109 | 195 | 26 |
158647 | 158647 | 2020-05-19 | Pearl River | Mississippi | 28109 | 195 | 27 |
161673 | 161673 | 2020-05-20 | Pearl River | Mississippi | 28109 | 197 | 27 |
164702 | 164702 | 2020-05-21 | Pearl River | Mississippi | 28109 | 197 | 27 |
167738 | 167738 | 2020-05-22 | Pearl River | Mississippi | 28109 | 203 | 27 |
170776 | 170776 | 2020-05-23 | Pearl River | Mississippi | 28109 | 203 | 27 |
173818 | 173818 | 2020-05-24 | Pearl River | Mississippi | 28109 | 202 | 27 |
176861 | 176861 | 2020-05-25 | Pearl River | Mississippi | 28109 | 205 | 27 |
179905 | 179905 | 2020-05-26 | Pearl River | Mississippi | 28109 | 205 | 30 |
182951 | 182951 | 2020-05-27 | Pearl River | Mississippi | 28109 | 207 | 31 |
186007 | 186007 | 2020-05-28 | Pearl River | Mississippi | 28109 | 206 | 31 |
189065 | 189065 | 2020-05-29 | Pearl River | Mississippi | 28109 | 207 | 31 |
192129 | 192129 | 2020-05-30 | Pearl River | Mississippi | 28109 | 209 | 31 |
195197 | 195197 | 2020-05-31 | Pearl River | Mississippi | 28109 | 209 | 31 |
198268 | 198268 | 2020-06-01 | Pearl River | Mississippi | 28109 | 209 | 31 |
201341 | 201341 | 2020-06-02 | Pearl River | Mississippi | 28109 | 211 | 31 |
204418 | 204418 | 2020-06-03 | Pearl River | Mississippi | 28109 | 212 | 31 |
207499 | 207499 | 2020-06-04 | Pearl River | Mississippi | 28109 | 212 | 31 |
210580 | 210580 | 2020-06-05 | Pearl River | Mississippi | 28109 | 212 | 31 |
213664 | 213664 | 2020-06-06 | Pearl River | Mississippi | 28109 | 213 | 31 |
216752 | 216752 | 2020-06-07 | Pearl River | Mississippi | 28109 | 215 | 31 |
219844 | 219844 | 2020-06-08 | Pearl River | Mississippi | 28109 | 217 | 31 |
222939 | 222939 | 2020-06-09 | Pearl River | Mississippi | 28109 | 221 | 31 |
226037 | 226037 | 2020-06-10 | Pearl River | Mississippi | 28109 | 221 | 31 |
229139 | 229139 | 2020-06-11 | Pearl River | Mississippi | 28109 | 221 | 31 |
232243 | 232243 | 2020-06-12 | Pearl River | Mississippi | 28109 | 219 | 31 |
235349 | 235349 | 2020-06-13 | Pearl River | Mississippi | 28109 | 221 | 31 |
238456 | 238456 | 2020-06-14 | Pearl River | Mississippi | 28109 | 222 | 31 |
241565 | 241565 | 2020-06-15 | Pearl River | Mississippi | 28109 | 223 | 31 |
244676 | 244676 | 2020-06-16 | Pearl River | Mississippi | 28109 | 223 | 31 |
247789 | 247789 | 2020-06-17 | Pearl River | Mississippi | 28109 | 224 | 32 |
250901 | 250901 | 2020-06-18 | Pearl River | Mississippi | 28109 | 224 | 32 |
254016 | 254016 | 2020-06-19 | Pearl River | Mississippi | 28109 | 224 | 32 |
257136 | 257136 | 2020-06-20 | Pearl River | Mississippi | 28109 | 224 | 32 |
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);