ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,097 rows where state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 330 ✖
- 0 2,100
- 1 1,192
- 2 383
- 14 283
- 6 260
- 11 255
- 7 242
- 10 224
- 5 221
- 4 219
- 15 219
- 12 198
- 3 176
- 13 163
- 17 148
- 8 146
- 19 146
- 20 141
- 31 138
- 70 135
- 21 131
- 16 120
- 34 120
- 35 106
- 18 105
- 45 105
- 57 104
- 36 95
- 38 92
- 29 89
- 56 89
- 27 86
- 9 83
- 33 79
- 32 77
- 52 77
- 71 77
- 54 76
- 28 70
- 85 68
- 22 67
- 23 65
- 89 65
- 30 64
- 88 64
- 26 63
- 41 63
- 44 63
- 59 61
- 43 56
- 48 56
- 55 56
- 68 56
- 74 56
- 87 56
- 40 53
- 47 52
- 79 52
- 145 50
- 24 49
- 25 49
- 86 49
- 53 48
- 50 47
- 69 44
- 72 44
- 143 43
- 46 41
- 90 41
- 101 41
- 81 39
- 284 39
- 49 36
- 58 35
- 37 34
- 63 34
- 110 34
- 51 33
- 134 33
- 93 32
- 67 31
- 65 30
- 73 30
- 111 30
- 131 30
- 76 29
- 82 28
- 97 28
- 125 27
- 236 27
- 106 26
- 66 25
- 104 25
- 139 25
- 200 25
- 60 24
- 99 24
- 185 23
- 325 23
- 39 22
- 61 21
- 62 21
- 96 21
- 102 21
- 112 21
- 94 20
- 109 20
- 205 20
- 84 19
- 206 19
- 64 18
- 83 18
- 127 18
- 129 18
- 149 18
- 173 18
- 190 18
- 195 18
- 197 18
- 103 17
- 192 17
- 100 16
- 117 16
- 186 16
- 42 15
- 140 15
- 142 15
- 148 15
- 183 15
- 204 15
- 254 15
- 78 14
- 95 14
- 156 14
- 163 14
- 179 14
- 189 14
- 77 13
- 114 13
- 136 13
- 137 13
- 146 13
- 170 13
- 188 13
- 213 13
- 215 13
- 227 13
- 265 13
- 285 13
- 357 13
- 80 12
- 91 12
- 115 12
- 120 12
- 130 12
- 133 12
- 144 12
- 151 12
- 157 12
- 194 12
- 218 12
- 223 12
- 274 12
- 92 11
- 121 11
- 126 11
- 128 11
- 203 11
- 209 11
- 225 11
- 321 11
- 107 10
- 153 10
- 158 10
- 172 10
- 184 10
- 228 10
- 270 10
- 308 10
- 315 10
- 347 10
- 169 9
- 201 9
- 221 9
- 235 9
- 266 9
- 346 9
- 98 8
- 116 8
- 123 8
- 165 8
- 180 8
- 210 8
- 212 8
- 234 8
- 239 8
- 250 8
- 260 8
- 268 8
- 113 7
- 119 7
- 124 7
- 154 7
- 167 7
- 226 7
- 232 7
- 248 7
- 255 7
- 272 7
- 295 7
- 331 7
- 339 7
- 105 6
- 122 6
- 141 6
- 147 6
- 162 6
- 166 6
- 176 6
- 198 6
- 202 6
- 217 6
- 243 6
- 259 6
- 271 6
- 275 6
- 319 6
- 341 6
- 343 6
- 358 6
- 108 5
- 138 5
- 182 5
- 191 5
- 216 5
- 224 5
- 244 5
- 258 5
- 262 5
- 264 5
- 281 5
- 287 5
- 293 5
- 323 5
- 326 5
- 118 4
- 135 4
- 159 4
- 160 4
- 211 4
- 222 4
- 229 4
- 237 4
- 241 4
- 245 4
- 257 4
- 286 4
- 290 4
- 291 4
- 303 4
- 320 4
- 352 4
- 364 4
- 132 3
- 150 3
- 164 3
- 168 3
- 174 3
- 178 3
- 181 3
- 187 3
- 193 3
- 196 3
- 199 3
- 214 3
- 219 3
- 251 3
- 261 3
- 273 3
- 306 3
- 155 2
- 161 2
- 177 2
- 207 2
- 208 2
- 220 2
- 238 2
- 246 2
- 247 2
- 263 2
- 267 2
- 269 2
- 277 2
- 283 2
- 311 2
- 314 2
- 348 2
- 366 2
- 75 1
- 171 1
- 175 1
- 230 1
- 231 1
- 240 1
- 242 1
- 252 1
- 253 1
- 256 1
- 278 1
- 280 1
- 294 1
- 298 1
- 300 1
- 304 1
- 307 1
- 313 1
- 317 1
- 322 1
- 328 1
- 329 1
- 335 1
- 336 1
- 351 1
- 355 1
- 359 1
- 360 1
- 361 1
- 362 1
- 363 1
- 365 1
fips 17
county 17
- Androscoggin 793
- Cumberland 792
- Lincoln 790
- Kennebec 788
- Oxford 788
- York 788
- Penobscot 787
- Sagadahoc 784
- Knox 782
- Waldo 781
- Franklin 779
- Somerset 776
- Hancock 773
- Aroostook 771
- Washington 771
- Piscataquis 755
- Unknown 599
state 1
- Maine · 13,097 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500764 | 2500764 | 2022-05-13 | Androscoggin | Maine | 23001 | 23257 | 285 |
2500765 | 2500765 | 2022-05-13 | Aroostook | Maine | 23003 | 14393 | 166 |
2500766 | 2500766 | 2022-05-13 | Cumberland | Maine | 23005 | 52557 | 366 |
2500767 | 2500767 | 2022-05-13 | Franklin | Maine | 23007 | 6014 | 60 |
2500768 | 2500768 | 2022-05-13 | Hancock | Maine | 23009 | 7983 | 87 |
2500769 | 2500769 | 2022-05-13 | Kennebec | Maine | 23011 | 24799 | 240 |
2500770 | 2500770 | 2022-05-13 | Knox | Maine | 23013 | 6414 | 38 |
2500771 | 2500771 | 2022-05-13 | Lincoln | Maine | 23015 | 5578 | 35 |
2500772 | 2500772 | 2022-05-13 | Oxford | Maine | 23017 | 11799 | 148 |
2500773 | 2500773 | 2022-05-13 | Penobscot | Maine | 23019 | 29710 | 331 |
2500774 | 2500774 | 2022-05-13 | Piscataquis | Maine | 23021 | 3112 | 31 |
2500775 | 2500775 | 2022-05-13 | Sagadahoc | Maine | 23023 | 5531 | 32 |
2500776 | 2500776 | 2022-05-13 | Somerset | Maine | 23025 | 10213 | 110 |
2500777 | 2500777 | 2022-05-13 | Unknown | Maine | 42 | 0 | |
2500778 | 2500778 | 2022-05-13 | Waldo | Maine | 23027 | 6467 | 58 |
2500779 | 2500779 | 2022-05-13 | Washington | Maine | 23029 | 4585 | 57 |
2500780 | 2500780 | 2022-05-13 | York | Maine | 23031 | 41973 | 291 |
2497506 | 2497506 | 2022-05-12 | Androscoggin | Maine | 23001 | 23208 | 285 |
2497507 | 2497507 | 2022-05-12 | Aroostook | Maine | 23003 | 14325 | 165 |
2497508 | 2497508 | 2022-05-12 | Cumberland | Maine | 23005 | 52361 | 366 |
2497509 | 2497509 | 2022-05-12 | Franklin | Maine | 23007 | 6007 | 60 |
2497510 | 2497510 | 2022-05-12 | Hancock | Maine | 23009 | 7954 | 87 |
2497511 | 2497511 | 2022-05-12 | Kennebec | Maine | 23011 | 24740 | 239 |
2497512 | 2497512 | 2022-05-12 | Knox | Maine | 23013 | 6391 | 38 |
2497513 | 2497513 | 2022-05-12 | Lincoln | Maine | 23015 | 5566 | 35 |
2497514 | 2497514 | 2022-05-12 | Oxford | Maine | 23017 | 11773 | 148 |
2497515 | 2497515 | 2022-05-12 | Penobscot | Maine | 23019 | 29594 | 331 |
2497516 | 2497516 | 2022-05-12 | Piscataquis | Maine | 23021 | 3105 | 31 |
2497517 | 2497517 | 2022-05-12 | Sagadahoc | Maine | 23023 | 5518 | 32 |
2497518 | 2497518 | 2022-05-12 | Somerset | Maine | 23025 | 10196 | 110 |
2497519 | 2497519 | 2022-05-12 | Unknown | Maine | 52 | 0 | |
2497520 | 2497520 | 2022-05-12 | Waldo | Maine | 23027 | 6447 | 58 |
2497521 | 2497521 | 2022-05-12 | Washington | Maine | 23029 | 4579 | 56 |
2497522 | 2497522 | 2022-05-12 | York | Maine | 23031 | 41838 | 291 |
2494248 | 2494248 | 2022-05-11 | Androscoggin | Maine | 23001 | 23169 | 285 |
2494249 | 2494249 | 2022-05-11 | Aroostook | Maine | 23003 | 14261 | 165 |
2494250 | 2494250 | 2022-05-11 | Cumberland | Maine | 23005 | 52104 | 365 |
2494251 | 2494251 | 2022-05-11 | Franklin | Maine | 23007 | 5996 | 60 |
2494252 | 2494252 | 2022-05-11 | Hancock | Maine | 23009 | 7895 | 87 |
2494253 | 2494253 | 2022-05-11 | Kennebec | Maine | 23011 | 24652 | 239 |
2494254 | 2494254 | 2022-05-11 | Knox | Maine | 23013 | 6381 | 37 |
2494255 | 2494255 | 2022-05-11 | Lincoln | Maine | 23015 | 5551 | 35 |
2494256 | 2494256 | 2022-05-11 | Oxford | Maine | 23017 | 11730 | 148 |
2494257 | 2494257 | 2022-05-11 | Penobscot | Maine | 23019 | 29473 | 331 |
2494258 | 2494258 | 2022-05-11 | Piscataquis | Maine | 23021 | 3093 | 31 |
2494259 | 2494259 | 2022-05-11 | Sagadahoc | Maine | 23023 | 5494 | 32 |
2494260 | 2494260 | 2022-05-11 | Somerset | Maine | 23025 | 10175 | 110 |
2494261 | 2494261 | 2022-05-11 | Unknown | Maine | 27 | 0 | |
2494262 | 2494262 | 2022-05-11 | Waldo | Maine | 23027 | 6420 | 58 |
2494263 | 2494263 | 2022-05-11 | Washington | Maine | 23029 | 4569 | 56 |
2494264 | 2494264 | 2022-05-11 | York | Maine | 23031 | 41663 | 291 |
2490990 | 2490990 | 2022-05-10 | Androscoggin | Maine | 23001 | 23123 | 285 |
2490991 | 2490991 | 2022-05-10 | Aroostook | Maine | 23003 | 14197 | 165 |
2490992 | 2490992 | 2022-05-10 | Cumberland | Maine | 23005 | 51910 | 364 |
2490993 | 2490993 | 2022-05-10 | Franklin | Maine | 23007 | 5985 | 59 |
2490994 | 2490994 | 2022-05-10 | Hancock | Maine | 23009 | 7843 | 87 |
2490995 | 2490995 | 2022-05-10 | Kennebec | Maine | 23011 | 24561 | 239 |
2490996 | 2490996 | 2022-05-10 | Knox | Maine | 23013 | 6360 | 37 |
2490997 | 2490997 | 2022-05-10 | Lincoln | Maine | 23015 | 5538 | 35 |
2490998 | 2490998 | 2022-05-10 | Oxford | Maine | 23017 | 11711 | 148 |
2490999 | 2490999 | 2022-05-10 | Penobscot | Maine | 23019 | 29383 | 331 |
2491000 | 2491000 | 2022-05-10 | Piscataquis | Maine | 23021 | 3091 | 31 |
2491001 | 2491001 | 2022-05-10 | Sagadahoc | Maine | 23023 | 5477 | 32 |
2491002 | 2491002 | 2022-05-10 | Somerset | Maine | 23025 | 10161 | 110 |
2491003 | 2491003 | 2022-05-10 | Unknown | Maine | 35 | 0 | |
2491004 | 2491004 | 2022-05-10 | Waldo | Maine | 23027 | 6399 | 57 |
2491005 | 2491005 | 2022-05-10 | Washington | Maine | 23029 | 4563 | 56 |
2491006 | 2491006 | 2022-05-10 | York | Maine | 23031 | 41568 | 291 |
2487733 | 2487733 | 2022-05-09 | Androscoggin | Maine | 23001 | 23086 | 285 |
2487734 | 2487734 | 2022-05-09 | Aroostook | Maine | 23003 | 14134 | 165 |
2487735 | 2487735 | 2022-05-09 | Cumberland | Maine | 23005 | 51689 | 364 |
2487736 | 2487736 | 2022-05-09 | Franklin | Maine | 23007 | 5978 | 59 |
2487737 | 2487737 | 2022-05-09 | Hancock | Maine | 23009 | 7812 | 87 |
2487738 | 2487738 | 2022-05-09 | Kennebec | Maine | 23011 | 24487 | 239 |
2487739 | 2487739 | 2022-05-09 | Knox | Maine | 23013 | 6340 | 37 |
2487740 | 2487740 | 2022-05-09 | Lincoln | Maine | 23015 | 5522 | 35 |
2487741 | 2487741 | 2022-05-09 | Oxford | Maine | 23017 | 11694 | 148 |
2487742 | 2487742 | 2022-05-09 | Penobscot | Maine | 23019 | 29281 | 331 |
2487743 | 2487743 | 2022-05-09 | Piscataquis | Maine | 23021 | 3083 | 31 |
2487744 | 2487744 | 2022-05-09 | Sagadahoc | Maine | 23023 | 5460 | 32 |
2487745 | 2487745 | 2022-05-09 | Somerset | Maine | 23025 | 10130 | 109 |
2487746 | 2487746 | 2022-05-09 | Unknown | Maine | 58 | 0 | |
2487747 | 2487747 | 2022-05-09 | Waldo | Maine | 23027 | 6381 | 57 |
2487748 | 2487748 | 2022-05-09 | Washington | Maine | 23029 | 4556 | 56 |
2487749 | 2487749 | 2022-05-09 | York | Maine | 23031 | 41443 | 290 |
2484475 | 2484475 | 2022-05-08 | Androscoggin | Maine | 23001 | 23061 | 285 |
2484476 | 2484476 | 2022-05-08 | Aroostook | Maine | 23003 | 14105 | 165 |
2484477 | 2484477 | 2022-05-08 | Cumberland | Maine | 23005 | 51574 | 364 |
2484478 | 2484478 | 2022-05-08 | Franklin | Maine | 23007 | 5974 | 59 |
2484479 | 2484479 | 2022-05-08 | Hancock | Maine | 23009 | 7793 | 87 |
2484480 | 2484480 | 2022-05-08 | Kennebec | Maine | 23011 | 24440 | 239 |
2484481 | 2484481 | 2022-05-08 | Knox | Maine | 23013 | 6333 | 37 |
2484482 | 2484482 | 2022-05-08 | Lincoln | Maine | 23015 | 5517 | 35 |
2484483 | 2484483 | 2022-05-08 | Oxford | Maine | 23017 | 11687 | 148 |
2484484 | 2484484 | 2022-05-08 | Penobscot | Maine | 23019 | 29230 | 331 |
2484485 | 2484485 | 2022-05-08 | Piscataquis | Maine | 23021 | 3080 | 31 |
2484486 | 2484486 | 2022-05-08 | Sagadahoc | Maine | 23023 | 5450 | 32 |
2484487 | 2484487 | 2022-05-08 | Somerset | Maine | 23025 | 10115 | 109 |
2484488 | 2484488 | 2022-05-08 | Unknown | Maine | 48 | 0 | |
2484489 | 2484489 | 2022-05-08 | Waldo | Maine | 23027 | 6368 | 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);