ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Charles" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 233 ✖
- 268 38
- 101 29
- 217 25
- 216 24
- 90 19
- 102 19
- 351 19
- 86 16
- 0 15
- 93 15
- 104 15
- 91 13
- 352 12
- 95 11
- 105 11
- 348 11
- 117 9
- 190 9
- 211 9
- 218 9
- 350 9
- 1 8
- 259 8
- 271 7
- 83 6
- 94 6
- 157 6
- 169 6
- 179 6
- 194 6
- 213 6
- 249 6
- 349 6
- 145 5
- 153 5
- 196 5
- 215 5
- 225 5
- 264 5
- 341 5
- 353 5
- 2 4
- 72 4
- 87 4
- 129 4
- 151 4
- 160 4
- 161 4
- 186 4
- 192 4
- 195 4
- 222 4
- 226 4
- 261 4
- 279 4
- 326 4
- 342 4
- 50 3
- 54 3
- 62 3
- 69 3
- 89 3
- 99 3
- 112 3
- 131 3
- 132 3
- 133 3
- 141 3
- 150 3
- 152 3
- 164 3
- 170 3
- 176 3
- 181 3
- 210 3
- 219 3
- 223 3
- 229 3
- 232 3
- 243 3
- 251 3
- 332 3
- 340 3
- 343 3
- 35 2
- 73 2
- 79 2
- 80 2
- 82 2
- 92 2
- 96 2
- 98 2
- 115 2
- 124 2
- 138 2
- 144 2
- 146 2
- 147 2
- 154 2
- 159 2
- 166 2
- 171 2
- 173 2
- 177 2
- 183 2
- 185 2
- 208 2
- 212 2
- 220 2
- 221 2
- 228 2
- 233 2
- 240 2
- 244 2
- 253 2
- 255 2
- 256 2
- 260 2
- 262 2
- 263 2
- 301 2
- 318 2
- 321 2
- 324 2
- 337 2
- 339 2
- 345 2
- 347 2
- 3 1
- 4 1
- 5 1
- 9 1
- 10 1
- 11 1
- 12 1
- 13 1
- 15 1
- 16 1
- 17 1
- 20 1
- 23 1
- 30 1
- 32 1
- 34 1
- 37 1
- 39 1
- 42 1
- 44 1
- 46 1
- 47 1
- 51 1
- 52 1
- 53 1
- 55 1
- 57 1
- 59 1
- 61 1
- 63 1
- 64 1
- 65 1
- 67 1
- 70 1
- 71 1
- 75 1
- 81 1
- 85 1
- 88 1
- 97 1
- 100 1
- 106 1
- 108 1
- 109 1
- 113 1
- 114 1
- 116 1
- 119 1
- 120 1
- 122 1
- 125 1
- 128 1
- 130 1
- 134 1
- 136 1
- 140 1
- 142 1
- 148 1
- 167 1
- 172 1
- 174 1
- 182 1
- 184 1
- 189 1
- 191 1
- 209 1
- 224 1
- 227 1
- 230 1
- 231 1
- 236 1
- 238 1
- 241 1
- 246 1
- 247 1
- 250 1
- 258 1
- 266 1
- 267 1
- 270 1
- 274 1
- 277 1
- 278 1
- 281 1
- 282 1
- 284 1
- 290 1
- 296 1
- 298 1
- 303 1
- 307 1
- 309 1
- 311 1
- 312 1
- 316 1
- 319 1
- 322 1
- 323 1
- 325 1
- 329 1
- 331 1
- 333 1
- 334 1
- 335 1
- 338 1
state 1
- Maryland 792
fips 1
- 24017 792
county 1
- Charles · 792 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500789 | 2500789 | 2022-05-13 | Charles | Maryland | 24017 | 28950 | 353 |
2497531 | 2497531 | 2022-05-12 | Charles | Maryland | 24017 | 28860 | 353 |
2494273 | 2494273 | 2022-05-11 | Charles | Maryland | 24017 | 28808 | 353 |
2491015 | 2491015 | 2022-05-10 | Charles | Maryland | 24017 | 28769 | 353 |
2487758 | 2487758 | 2022-05-09 | Charles | Maryland | 24017 | 28658 | 353 |
2484500 | 2484500 | 2022-05-08 | Charles | Maryland | 24017 | 28623 | 352 |
2481242 | 2481242 | 2022-05-07 | Charles | Maryland | 24017 | 28623 | 352 |
2477984 | 2477984 | 2022-05-06 | Charles | Maryland | 24017 | 28623 | 352 |
2474726 | 2474726 | 2022-05-05 | Charles | Maryland | 24017 | 28579 | 352 |
2471469 | 2471469 | 2022-05-04 | Charles | Maryland | 24017 | 28545 | 352 |
2468213 | 2468213 | 2022-05-03 | Charles | Maryland | 24017 | 28522 | 352 |
2464958 | 2464958 | 2022-05-02 | Charles | Maryland | 24017 | 28460 | 352 |
2461702 | 2461702 | 2022-05-01 | Charles | Maryland | 24017 | 28422 | 352 |
2458446 | 2458446 | 2022-04-30 | Charles | Maryland | 24017 | 28422 | 352 |
2455190 | 2455190 | 2022-04-29 | Charles | Maryland | 24017 | 28422 | 352 |
2451934 | 2451934 | 2022-04-28 | Charles | Maryland | 24017 | 28368 | 352 |
2448678 | 2448678 | 2022-04-27 | Charles | Maryland | 24017 | 28341 | 352 |
2445422 | 2445422 | 2022-04-26 | Charles | Maryland | 24017 | 28331 | 351 |
2442166 | 2442166 | 2022-04-25 | Charles | Maryland | 24017 | 28270 | 351 |
2438910 | 2438910 | 2022-04-24 | Charles | Maryland | 24017 | 28249 | 351 |
2435654 | 2435654 | 2022-04-23 | Charles | Maryland | 24017 | 28249 | 351 |
2432398 | 2432398 | 2022-04-22 | Charles | Maryland | 24017 | 28249 | 351 |
2429142 | 2429142 | 2022-04-21 | Charles | Maryland | 24017 | 28233 | 351 |
2425886 | 2425886 | 2022-04-20 | Charles | Maryland | 24017 | 28207 | 351 |
2422630 | 2422630 | 2022-04-19 | Charles | Maryland | 24017 | 28194 | 351 |
2419374 | 2419374 | 2022-04-18 | Charles | Maryland | 24017 | 28115 | 351 |
2416118 | 2416118 | 2022-04-17 | Charles | Maryland | 24017 | 28096 | 351 |
2412862 | 2412862 | 2022-04-16 | Charles | Maryland | 24017 | 28096 | 351 |
2409606 | 2409606 | 2022-04-15 | Charles | Maryland | 24017 | 28096 | 351 |
2406350 | 2406350 | 2022-04-14 | Charles | Maryland | 24017 | 28070 | 351 |
2403094 | 2403094 | 2022-04-13 | Charles | Maryland | 24017 | 28036 | 351 |
2399840 | 2399840 | 2022-04-12 | Charles | Maryland | 24017 | 28026 | 351 |
2396584 | 2396584 | 2022-04-11 | Charles | Maryland | 24017 | 28002 | 351 |
2393329 | 2393329 | 2022-04-10 | Charles | Maryland | 24017 | 27954 | 351 |
2390073 | 2390073 | 2022-04-09 | Charles | Maryland | 24017 | 27954 | 351 |
2386817 | 2386817 | 2022-04-08 | Charles | Maryland | 24017 | 27954 | 351 |
2383562 | 2383562 | 2022-04-07 | Charles | Maryland | 24017 | 27943 | 350 |
2380307 | 2380307 | 2022-04-06 | Charles | Maryland | 24017 | 27927 | 350 |
2377052 | 2377052 | 2022-04-05 | Charles | Maryland | 24017 | 27904 | 350 |
2373800 | 2373800 | 2022-04-04 | Charles | Maryland | 24017 | 27900 | 350 |
2370547 | 2370547 | 2022-04-03 | Charles | Maryland | 24017 | 27866 | 350 |
2367294 | 2367294 | 2022-04-02 | Charles | Maryland | 24017 | 27866 | 350 |
2364041 | 2364041 | 2022-04-01 | Charles | Maryland | 24017 | 27866 | 350 |
2360787 | 2360787 | 2022-03-31 | Charles | Maryland | 24017 | 27855 | 350 |
2357533 | 2357533 | 2022-03-30 | Charles | Maryland | 24017 | 27846 | 350 |
2354280 | 2354280 | 2022-03-29 | Charles | Maryland | 24017 | 27839 | 349 |
2351028 | 2351028 | 2022-03-28 | Charles | Maryland | 24017 | 27836 | 349 |
2347775 | 2347775 | 2022-03-27 | Charles | Maryland | 24017 | 27822 | 349 |
2344522 | 2344522 | 2022-03-26 | Charles | Maryland | 24017 | 27813 | 349 |
2341269 | 2341269 | 2022-03-25 | Charles | Maryland | 24017 | 27804 | 349 |
2338016 | 2338016 | 2022-03-24 | Charles | Maryland | 24017 | 27795 | 349 |
2334762 | 2334762 | 2022-03-23 | Charles | Maryland | 24017 | 27786 | 348 |
2331508 | 2331508 | 2022-03-22 | Charles | Maryland | 24017 | 27781 | 348 |
2328256 | 2328256 | 2022-03-21 | Charles | Maryland | 24017 | 27780 | 348 |
2325003 | 2325003 | 2022-03-20 | Charles | Maryland | 24017 | 27775 | 348 |
2321749 | 2321749 | 2022-03-19 | Charles | Maryland | 24017 | 27765 | 348 |
2318495 | 2318495 | 2022-03-18 | Charles | Maryland | 24017 | 27752 | 348 |
2315242 | 2315242 | 2022-03-17 | Charles | Maryland | 24017 | 27732 | 348 |
2311989 | 2311989 | 2022-03-16 | Charles | Maryland | 24017 | 27727 | 348 |
2308736 | 2308736 | 2022-03-15 | Charles | Maryland | 24017 | 27724 | 348 |
2305485 | 2305485 | 2022-03-14 | Charles | Maryland | 24017 | 27720 | 348 |
2302233 | 2302233 | 2022-03-13 | Charles | Maryland | 24017 | 27706 | 348 |
2298981 | 2298981 | 2022-03-12 | Charles | Maryland | 24017 | 27704 | 347 |
2295729 | 2295729 | 2022-03-11 | Charles | Maryland | 24017 | 27696 | 347 |
2292477 | 2292477 | 2022-03-10 | Charles | Maryland | 24017 | 27684 | 345 |
2289225 | 2289225 | 2022-03-09 | Charles | Maryland | 24017 | 27669 | 345 |
2285974 | 2285974 | 2022-03-08 | Charles | Maryland | 24017 | 27658 | 343 |
2282722 | 2282722 | 2022-03-07 | Charles | Maryland | 24017 | 27653 | 343 |
2279469 | 2279469 | 2022-03-06 | Charles | Maryland | 24017 | 27645 | 343 |
2276216 | 2276216 | 2022-03-05 | Charles | Maryland | 24017 | 27633 | 342 |
2272963 | 2272963 | 2022-03-04 | Charles | Maryland | 24017 | 27619 | 342 |
2269711 | 2269711 | 2022-03-03 | Charles | Maryland | 24017 | 27612 | 342 |
2266458 | 2266458 | 2022-03-02 | Charles | Maryland | 24017 | 27601 | 342 |
2263207 | 2263207 | 2022-03-01 | Charles | Maryland | 24017 | 27590 | 341 |
2259956 | 2259956 | 2022-02-28 | Charles | Maryland | 24017 | 27579 | 341 |
2256705 | 2256705 | 2022-02-27 | Charles | Maryland | 24017 | 27571 | 341 |
2253454 | 2253454 | 2022-02-26 | Charles | Maryland | 24017 | 27560 | 341 |
2250203 | 2250203 | 2022-02-25 | Charles | Maryland | 24017 | 27534 | 341 |
2246952 | 2246952 | 2022-02-24 | Charles | Maryland | 24017 | 27525 | 340 |
2243701 | 2243701 | 2022-02-23 | Charles | Maryland | 24017 | 27514 | 340 |
2240450 | 2240450 | 2022-02-22 | Charles | Maryland | 24017 | 27506 | 340 |
2237199 | 2237199 | 2022-02-21 | Charles | Maryland | 24017 | 27479 | 339 |
2233948 | 2233948 | 2022-02-20 | Charles | Maryland | 24017 | 27479 | 339 |
2230697 | 2230697 | 2022-02-19 | Charles | Maryland | 24017 | 27472 | 338 |
2227446 | 2227446 | 2022-02-18 | Charles | Maryland | 24017 | 27444 | 337 |
2224195 | 2224195 | 2022-02-17 | Charles | Maryland | 24017 | 27416 | 337 |
2220944 | 2220944 | 2022-02-16 | Charles | Maryland | 24017 | 27396 | 335 |
2217693 | 2217693 | 2022-02-15 | Charles | Maryland | 24017 | 26818 | 334 |
2214442 | 2214442 | 2022-02-14 | Charles | Maryland | 24017 | 26803 | 333 |
2211190 | 2211190 | 2022-02-13 | Charles | Maryland | 24017 | 26777 | 332 |
2207937 | 2207937 | 2022-02-12 | Charles | Maryland | 24017 | 26763 | 332 |
2204684 | 2204684 | 2022-02-11 | Charles | Maryland | 24017 | 26728 | 332 |
2201431 | 2201431 | 2022-02-10 | Charles | Maryland | 24017 | 26652 | 331 |
2198177 | 2198177 | 2022-02-09 | Charles | Maryland | 24017 | 26594 | 329 |
2194923 | 2194923 | 2022-02-08 | Charles | Maryland | 24017 | 26581 | 326 |
2191669 | 2191669 | 2022-02-07 | Charles | Maryland | 24017 | 26556 | 326 |
2188416 | 2188416 | 2022-02-06 | Charles | Maryland | 24017 | 26537 | 326 |
2185163 | 2185163 | 2022-02-05 | Charles | Maryland | 24017 | 26520 | 326 |
2181911 | 2181911 | 2022-02-04 | Charles | Maryland | 24017 | 26465 | 325 |
2178659 | 2178659 | 2022-02-03 | Charles | Maryland | 24017 | 26408 | 324 |
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);