ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,569 rows where county = "Frederick" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 346 ✖
- 0 50
- 13 41
- 102 40
- 4 37
- 104 36
- 120 25
- 397 25
- 121 23
- 11 22
- 103 21
- 244 20
- 344 20
- 7 17
- 10 17
- 95 17
- 6 15
- 9 15
- 96 15
- 100 14
- 348 14
- 47 13
- 140 13
- 241 13
- 342 13
- 3 12
- 188 12
- 517 12
- 341 11
- 524 11
- 1 10
- 2 10
- 101 10
- 105 10
- 131 10
- 146 10
- 325 10
- 19 9
- 97 9
- 133 9
- 139 9
- 150 9
- 164 9
- 228 9
- 320 9
- 345 9
- 351 9
- 17 8
- 107 8
- 116 8
- 117 8
- 124 8
- 138 8
- 185 8
- 15 7
- 24 7
- 45 7
- 94 7
- 123 7
- 127 7
- 137 7
- 243 7
- 247 7
- 287 7
- 350 7
- 18 6
- 30 6
- 35 6
- 125 6
- 129 6
- 135 6
- 151 6
- 158 6
- 165 6
- 245 6
- 338 6
- 363 6
- 366 6
- 372 6
- 377 6
- 390 6
- 512 6
- 16 5
- 25 5
- 42 5
- 111 5
- 114 5
- 115 5
- 167 5
- 182 5
- 224 5
- 246 5
- 281 5
- 301 5
- 305 5
- 321 5
- 375 5
- 386 5
- 519 5
- 521 5
- 14 4
- 33 4
- 37 4
- 88 4
- 98 4
- 106 4
- 113 4
- 128 4
- 134 4
- 141 4
- 153 4
- 154 4
- 155 4
- 160 4
- 161 4
- 222 4
- 233 4
- 256 4
- 300 4
- 322 4
- 339 4
- 343 4
- 359 4
- 368 4
- 379 4
- 417 4
- 501 4
- 503 4
- 509 4
- 510 4
- 516 4
- 518 4
- 525 4
- 5 3
- 12 3
- 22 3
- 27 3
- 48 3
- 56 3
- 74 3
- 90 3
- 112 3
- 148 3
- 149 3
- 152 3
- 170 3
- 180 3
- 184 3
- 192 3
- 194 3
- 201 3
- 209 3
- 213 3
- 215 3
- 217 3
- 221 3
- 232 3
- 267 3
- 302 3
- 319 3
- 340 3
- 349 3
- 353 3
- 367 3
- 388 3
- 392 3
- 423 3
- 464 3
- 497 3
- 499 3
- 515 3
- 522 3
- 23 2
- 28 2
- 38 2
- 39 2
- 49 2
- 59 2
- 61 2
- 66 2
- 68 2
- 70 2
- 72 2
- 85 2
- 87 2
- 91 2
- 93 2
- 99 2
- 109 2
- 110 2
- 118 2
- 122 2
- 126 2
- 144 2
- 156 2
- 166 2
- 171 2
- 174 2
- 189 2
- 190 2
- 196 2
- 198 2
- 200 2
- 226 2
- 229 2
- 234 2
- 237 2
- 240 2
- 242 2
- 248 2
- 257 2
- 261 2
- 263 2
- 265 2
- 280 2
- 283 2
- 292 2
- 296 2
- 306 2
- 309 2
- 314 2
- 324 2
- 347 2
- 352 2
- 360 2
- 382 2
- 389 2
- 393 2
- 419 2
- 428 2
- 479 2
- 488 2
- 489 2
- 490 2
- 500 2
- 504 2
- 507 2
- 508 2
- 20 1
- 29 1
- 31 1
- 32 1
- 36 1
- 40 1
- 41 1
- 43 1
- 44 1
- 50 1
- 51 1
- 53 1
- 55 1
- 62 1
- 64 1
- 77 1
- 80 1
- 84 1
- 89 1
- 119 1
- 130 1
- 132 1
- 142 1
- 159 1
- 163 1
- 168 1
- 172 1
- 175 1
- 176 1
- 177 1
- 178 1
- 179 1
- 181 1
- 186 1
- 191 1
- 197 1
- 202 1
- 204 1
- 205 1
- 211 1
- 212 1
- 214 1
- 223 1
- 231 1
- 235 1
- 238 1
- 239 1
- 249 1
- 250 1
- 251 1
- 253 1
- 260 1
- 264 1
- 266 1
- 269 1
- 272 1
- 276 1
- 278 1
- 282 1
- 286 1
- 289 1
- 291 1
- 293 1
- 297 1
- 298 1
- 303 1
- 307 1
- 308 1
- 312 1
- 316 1
- 355 1
- 356 1
- 357 1
- 361 1
- 369 1
- 373 1
- 376 1
- 381 1
- 384 1
- 385 1
- 396 1
- 413 1
- 426 1
- 427 1
- 433 1
- 434 1
- 436 1
- 437 1
- 438 1
- 442 1
- 443 1
- 446 1
- 452 1
- 457 1
- 458 1
- 466 1
- 470 1
- 472 1
- 474 1
- 480 1
- 483 1
- 485 1
- 486 1
- 494 1
- 498 1
- 502 1
- 505 1
- 514 1
- 523 1
county 1
- Frederick · 1,569 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500791 | 2500791 | 2022-05-13 | Frederick | Maryland | 24021 | 46920 | 525 |
2502555 | 2502555 | 2022-05-13 | Frederick | Virginia | 51069 | 20904 | 249 |
2497533 | 2497533 | 2022-05-12 | Frederick | Maryland | 24021 | 46839 | 525 |
2499297 | 2499297 | 2022-05-12 | Frederick | Virginia | 51069 | 20874 | 248 |
2494275 | 2494275 | 2022-05-11 | Frederick | Maryland | 24021 | 46763 | 525 |
2496039 | 2496039 | 2022-05-11 | Frederick | Virginia | 51069 | 20854 | 248 |
2491017 | 2491017 | 2022-05-10 | Frederick | Maryland | 24021 | 46709 | 525 |
2492781 | 2492781 | 2022-05-10 | Frederick | Virginia | 51069 | 20839 | 247 |
2487760 | 2487760 | 2022-05-09 | Frederick | Maryland | 24021 | 46549 | 524 |
2489523 | 2489523 | 2022-05-09 | Frederick | Virginia | 51069 | 20815 | 247 |
2484502 | 2484502 | 2022-05-08 | Frederick | Maryland | 24021 | 46483 | 524 |
2486266 | 2486266 | 2022-05-08 | Frederick | Virginia | 51069 | 20765 | 247 |
2481244 | 2481244 | 2022-05-07 | Frederick | Maryland | 24021 | 46483 | 524 |
2483008 | 2483008 | 2022-05-07 | Frederick | Virginia | 51069 | 20765 | 247 |
2477986 | 2477986 | 2022-05-06 | Frederick | Maryland | 24021 | 46483 | 524 |
2479750 | 2479750 | 2022-05-06 | Frederick | Virginia | 51069 | 20765 | 247 |
2474728 | 2474728 | 2022-05-05 | Frederick | Maryland | 24021 | 46407 | 524 |
2476492 | 2476492 | 2022-05-05 | Frederick | Virginia | 51069 | 20746 | 247 |
2471471 | 2471471 | 2022-05-04 | Frederick | Maryland | 24021 | 46365 | 524 |
2473234 | 2473234 | 2022-05-04 | Frederick | Virginia | 51069 | 20725 | 247 |
2468215 | 2468215 | 2022-05-03 | Frederick | Maryland | 24021 | 46318 | 524 |
2469978 | 2469978 | 2022-05-03 | Frederick | Virginia | 51069 | 20712 | 246 |
2464960 | 2464960 | 2022-05-02 | Frederick | Maryland | 24021 | 46239 | 524 |
2466722 | 2466722 | 2022-05-02 | Frederick | Virginia | 51069 | 20704 | 246 |
2461704 | 2461704 | 2022-05-01 | Frederick | Maryland | 24021 | 46195 | 524 |
2463467 | 2463467 | 2022-05-01 | Frederick | Virginia | 51069 | 20687 | 246 |
2458448 | 2458448 | 2022-04-30 | Frederick | Maryland | 24021 | 46195 | 524 |
2460211 | 2460211 | 2022-04-30 | Frederick | Virginia | 51069 | 20687 | 246 |
2455192 | 2455192 | 2022-04-29 | Frederick | Maryland | 24021 | 46195 | 524 |
2456955 | 2456955 | 2022-04-29 | Frederick | Virginia | 51069 | 20687 | 246 |
2451936 | 2451936 | 2022-04-28 | Frederick | Maryland | 24021 | 46142 | 523 |
2453699 | 2453699 | 2022-04-28 | Frederick | Virginia | 51069 | 20673 | 245 |
2448680 | 2448680 | 2022-04-27 | Frederick | Maryland | 24021 | 46094 | 522 |
2450443 | 2450443 | 2022-04-27 | Frederick | Virginia | 51069 | 20660 | 245 |
2445424 | 2445424 | 2022-04-26 | Frederick | Maryland | 24021 | 46070 | 522 |
2447186 | 2447186 | 2022-04-26 | Frederick | Virginia | 51069 | 20647 | 245 |
2442168 | 2442168 | 2022-04-25 | Frederick | Maryland | 24021 | 45999 | 522 |
2443931 | 2443931 | 2022-04-25 | Frederick | Virginia | 51069 | 20634 | 245 |
2438912 | 2438912 | 2022-04-24 | Frederick | Maryland | 24021 | 45965 | 521 |
2440675 | 2440675 | 2022-04-24 | Frederick | Virginia | 51069 | 20625 | 244 |
2435656 | 2435656 | 2022-04-23 | Frederick | Maryland | 24021 | 45965 | 521 |
2437419 | 2437419 | 2022-04-23 | Frederick | Virginia | 51069 | 20625 | 244 |
2432400 | 2432400 | 2022-04-22 | Frederick | Maryland | 24021 | 45965 | 521 |
2434163 | 2434163 | 2022-04-22 | Frederick | Virginia | 51069 | 20625 | 244 |
2429144 | 2429144 | 2022-04-21 | Frederick | Maryland | 24021 | 45939 | 521 |
2430907 | 2430907 | 2022-04-21 | Frederick | Virginia | 51069 | 20617 | 244 |
2425888 | 2425888 | 2022-04-20 | Frederick | Maryland | 24021 | 45913 | 521 |
2427651 | 2427651 | 2022-04-20 | Frederick | Virginia | 51069 | 20604 | 244 |
2422632 | 2422632 | 2022-04-19 | Frederick | Maryland | 24021 | 45883 | 519 |
2424395 | 2424395 | 2022-04-19 | Frederick | Virginia | 51069 | 20599 | 244 |
2419376 | 2419376 | 2022-04-18 | Frederick | Maryland | 24021 | 45814 | 519 |
2421139 | 2421139 | 2022-04-18 | Frederick | Virginia | 51069 | 20591 | 244 |
2416120 | 2416120 | 2022-04-17 | Frederick | Maryland | 24021 | 45780 | 519 |
2417883 | 2417883 | 2022-04-17 | Frederick | Virginia | 51069 | 20580 | 244 |
2412864 | 2412864 | 2022-04-16 | Frederick | Maryland | 24021 | 45780 | 519 |
2414627 | 2414627 | 2022-04-16 | Frederick | Virginia | 51069 | 20580 | 244 |
2409608 | 2409608 | 2022-04-15 | Frederick | Maryland | 24021 | 45780 | 519 |
2411371 | 2411371 | 2022-04-15 | Frederick | Virginia | 51069 | 20580 | 244 |
2406352 | 2406352 | 2022-04-14 | Frederick | Maryland | 24021 | 45748 | 518 |
2408115 | 2408115 | 2022-04-14 | Frederick | Virginia | 51069 | 20572 | 244 |
2403096 | 2403096 | 2022-04-13 | Frederick | Maryland | 24021 | 45722 | 518 |
2404859 | 2404859 | 2022-04-13 | Frederick | Virginia | 51069 | 20563 | 244 |
2399842 | 2399842 | 2022-04-12 | Frederick | Maryland | 24021 | 45705 | 518 |
2401604 | 2401604 | 2022-04-12 | Frederick | Virginia | 51069 | 20551 | 244 |
2396586 | 2396586 | 2022-04-11 | Frederick | Maryland | 24021 | 45693 | 518 |
2398349 | 2398349 | 2022-04-11 | Frederick | Virginia | 51069 | 20545 | 244 |
2393331 | 2393331 | 2022-04-10 | Frederick | Maryland | 24021 | 45641 | 517 |
2395094 | 2395094 | 2022-04-10 | Frederick | Virginia | 51069 | 20544 | 244 |
2390075 | 2390075 | 2022-04-09 | Frederick | Maryland | 24021 | 45641 | 517 |
2391838 | 2391838 | 2022-04-09 | Frederick | Virginia | 51069 | 20544 | 244 |
2386819 | 2386819 | 2022-04-08 | Frederick | Maryland | 24021 | 45641 | 517 |
2388582 | 2388582 | 2022-04-08 | Frederick | Virginia | 51069 | 20544 | 244 |
2383564 | 2383564 | 2022-04-07 | Frederick | Maryland | 24021 | 45626 | 517 |
2385327 | 2385327 | 2022-04-07 | Frederick | Virginia | 51069 | 20548 | 244 |
2380309 | 2380309 | 2022-04-06 | Frederick | Maryland | 24021 | 45601 | 517 |
2382072 | 2382072 | 2022-04-06 | Frederick | Virginia | 51069 | 20557 | 244 |
2377054 | 2377054 | 2022-04-05 | Frederick | Maryland | 24021 | 45580 | 517 |
2378817 | 2378817 | 2022-04-05 | Frederick | Virginia | 51069 | 20564 | 243 |
2373802 | 2373802 | 2022-04-04 | Frederick | Maryland | 24021 | 45569 | 517 |
2375563 | 2375563 | 2022-04-04 | Frederick | Virginia | 51069 | 20564 | 243 |
2370549 | 2370549 | 2022-04-03 | Frederick | Maryland | 24021 | 45539 | 517 |
2372311 | 2372311 | 2022-04-03 | Frederick | Virginia | 51069 | 20551 | 243 |
2367296 | 2367296 | 2022-04-02 | Frederick | Maryland | 24021 | 45539 | 517 |
2369058 | 2369058 | 2022-04-02 | Frederick | Virginia | 51069 | 20551 | 243 |
2364043 | 2364043 | 2022-04-01 | Frederick | Maryland | 24021 | 45539 | 517 |
2365805 | 2365805 | 2022-04-01 | Frederick | Virginia | 51069 | 20551 | 243 |
2360789 | 2360789 | 2022-03-31 | Frederick | Maryland | 24021 | 45530 | 517 |
2362552 | 2362552 | 2022-03-31 | Frederick | Virginia | 51069 | 20550 | 242 |
2357535 | 2357535 | 2022-03-30 | Frederick | Maryland | 24021 | 45517 | 517 |
2359298 | 2359298 | 2022-03-30 | Frederick | Virginia | 51069 | 20546 | 242 |
2354282 | 2354282 | 2022-03-29 | Frederick | Maryland | 24021 | 45509 | 516 |
2356044 | 2356044 | 2022-03-29 | Frederick | Virginia | 51069 | 20542 | 241 |
2351030 | 2351030 | 2022-03-28 | Frederick | Maryland | 24021 | 45495 | 516 |
2352791 | 2352791 | 2022-03-28 | Frederick | Virginia | 51069 | 20535 | 241 |
2347777 | 2347777 | 2022-03-27 | Frederick | Maryland | 24021 | 45485 | 516 |
2349539 | 2349539 | 2022-03-27 | Frederick | Virginia | 51069 | 20530 | 241 |
2344524 | 2344524 | 2022-03-26 | Frederick | Maryland | 24021 | 45469 | 516 |
2346286 | 2346286 | 2022-03-26 | Frederick | Virginia | 51069 | 20530 | 241 |
2341271 | 2341271 | 2022-03-25 | Frederick | Maryland | 24021 | 45452 | 515 |
2343033 | 2343033 | 2022-03-25 | Frederick | Virginia | 51069 | 20530 | 241 |
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);