ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 24033 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
927 | 927 | 2020-03-09 | Prince George's | Maryland | 24033 | 1 | 0 |
1073 | 1073 | 2020-03-10 | Prince George's | Maryland | 24033 | 3 | 0 |
1253 | 1253 | 2020-03-11 | Prince George's | Maryland | 24033 | 5 | 0 |
1471 | 1471 | 2020-03-12 | Prince George's | Maryland | 24033 | 5 | 0 |
1750 | 1750 | 2020-03-13 | Prince George's | Maryland | 24033 | 7 | 0 |
2091 | 2091 | 2020-03-14 | Prince George's | Maryland | 24033 | 7 | 0 |
2492 | 2492 | 2020-03-15 | Prince George's | Maryland | 24033 | 9 | 0 |
2940 | 2940 | 2020-03-16 | Prince George's | Maryland | 24033 | 10 | 0 |
3441 | 3441 | 2020-03-17 | Prince George's | Maryland | 24033 | 14 | 0 |
4023 | 4023 | 2020-03-18 | Prince George's | Maryland | 24033 | 20 | 1 |
4726 | 4726 | 2020-03-19 | Prince George's | Maryland | 24033 | 23 | 1 |
5544 | 5544 | 2020-03-20 | Prince George's | Maryland | 24033 | 31 | 1 |
6501 | 6501 | 2020-03-21 | Prince George's | Maryland | 24033 | 36 | 1 |
7577 | 7577 | 2020-03-22 | Prince George's | Maryland | 24033 | 40 | 1 |
8748 | 8748 | 2020-03-23 | Prince George's | Maryland | 24033 | 47 | 1 |
10037 | 10037 | 2020-03-24 | Prince George's | Maryland | 24033 | 63 | 2 |
11448 | 11448 | 2020-03-25 | Prince George's | Maryland | 24033 | 76 | 2 |
13029 | 13029 | 2020-03-26 | Prince George's | Maryland | 24033 | 101 | 2 |
14737 | 14737 | 2020-03-27 | Prince George's | Maryland | 24033 | 148 | 2 |
16557 | 16557 | 2020-03-28 | Prince George's | Maryland | 24033 | 196 | 3 |
18472 | 18472 | 2020-03-29 | Prince George's | Maryland | 24033 | 247 | 3 |
20488 | 20488 | 2020-03-30 | Prince George's | Maryland | 24033 | 294 | 6 |
22597 | 22597 | 2020-03-31 | Prince George's | Maryland | 24033 | 341 | 7 |
24775 | 24775 | 2020-04-01 | Prince George's | Maryland | 24033 | 403 | 7 |
27027 | 27027 | 2020-04-02 | Prince George's | Maryland | 24033 | 473 | 7 |
29346 | 29346 | 2020-04-03 | Prince George's | Maryland | 24033 | 563 | 9 |
31724 | 31724 | 2020-04-04 | Prince George's | Maryland | 24033 | 653 | 13 |
34149 | 34149 | 2020-04-05 | Prince George's | Maryland | 24033 | 785 | 16 |
36608 | 36608 | 2020-04-06 | Prince George's | Maryland | 24033 | 916 | 23 |
39116 | 39116 | 2020-04-07 | Prince George's | Maryland | 24033 | 1020 | 26 |
41668 | 41668 | 2020-04-08 | Prince George's | Maryland | 24033 | 1310 | 32 |
44244 | 44244 | 2020-04-09 | Prince George's | Maryland | 24033 | 1476 | 35 |
46852 | 46852 | 2020-04-10 | Prince George's | Maryland | 24033 | 1716 | 42 |
49494 | 49494 | 2020-04-11 | Prince George's | Maryland | 24033 | 1923 | 50 |
52164 | 52164 | 2020-04-12 | Prince George's | Maryland | 24033 | 2035 | 55 |
54845 | 54845 | 2020-04-13 | Prince George's | Maryland | 24033 | 2205 | 63 |
57543 | 57543 | 2020-04-14 | Prince George's | Maryland | 24033 | 2356 | 72 |
60251 | 60251 | 2020-04-15 | Prince George's | Maryland | 24033 | 2527 | 76 |
62972 | 62972 | 2020-04-16 | Prince George's | Maryland | 24033 | 2732 | 80 |
65710 | 65710 | 2020-04-17 | Prince George's | Maryland | 24033 | 2976 | 87 |
68460 | 68460 | 2020-04-18 | Prince George's | Maryland | 24033 | 3170 | 95 |
71224 | 71224 | 2020-04-19 | Prince George's | Maryland | 24033 | 3352 | 105 |
73996 | 73996 | 2020-04-20 | Prince George's | Maryland | 24033 | 3592 | 112 |
76776 | 76776 | 2020-04-21 | Prince George's | Maryland | 24033 | 3741 | 118 |
79562 | 79562 | 2020-04-22 | Prince George's | Maryland | 24033 | 3882 | 132 |
82357 | 82357 | 2020-04-23 | Prince George's | Maryland | 24033 | 4150 | 150 |
85161 | 85161 | 2020-04-24 | Prince George's | Maryland | 24033 | 4414 | 158 |
87971 | 87971 | 2020-04-25 | Prince George's | Maryland | 24033 | 4806 | 173 |
90787 | 90787 | 2020-04-26 | Prince George's | Maryland | 24033 | 4998 | 174 |
93608 | 93608 | 2020-04-27 | Prince George's | Maryland | 24033 | 5274 | 198 |
96443 | 96443 | 2020-04-28 | Prince George's | Maryland | 24033 | 5507 | 206 |
99289 | 99289 | 2020-04-29 | Prince George's | Maryland | 24033 | 5749 | 224 |
102141 | 102141 | 2020-04-30 | Prince George's | Maryland | 24033 | 6054 | 240 |
105001 | 105001 | 2020-05-01 | Prince George's | Maryland | 24033 | 6747 | 243 |
107865 | 107865 | 2020-05-02 | Prince George's | Maryland | 24033 | 7053 | 269 |
110737 | 110737 | 2020-05-03 | Prince George's | Maryland | 24033 | 7345 | 277 |
113615 | 113615 | 2020-05-04 | Prince George's | Maryland | 24033 | 7611 | 284 |
116496 | 116496 | 2020-05-05 | Prince George's | Maryland | 24033 | 7846 | 295 |
119457 | 119457 | 2020-05-06 | Prince George's | Maryland | 24033 | 8150 | 311 |
122429 | 122429 | 2020-05-07 | Prince George's | Maryland | 24033 | 8531 | 324 |
125411 | 125411 | 2020-05-08 | Prince George's | Maryland | 24033 | 8917 | 339 |
128398 | 128398 | 2020-05-09 | Prince George's | Maryland | 24033 | 9221 | 349 |
131388 | 131388 | 2020-05-10 | Prince George's | Maryland | 24033 | 9512 | 353 |
134379 | 134379 | 2020-05-11 | Prince George's | Maryland | 24033 | 9704 | 359 |
137369 | 137369 | 2020-05-12 | Prince George's | Maryland | 24033 | 9910 | 373 |
140363 | 140363 | 2020-05-13 | Prince George's | Maryland | 24033 | 10091 | 389 |
143358 | 143358 | 2020-05-14 | Prince George's | Maryland | 24033 | 10468 | 398 |
146358 | 146358 | 2020-05-15 | Prince George's | Maryland | 24033 | 10811 | 413 |
149363 | 149363 | 2020-05-16 | Prince George's | Maryland | 24033 | 11052 | 420 |
152374 | 152374 | 2020-05-17 | Prince George's | Maryland | 24033 | 11337 | 429 |
155388 | 155388 | 2020-05-18 | Prince George's | Maryland | 24033 | 11629 | 436 |
158406 | 158406 | 2020-05-19 | Prince George's | Maryland | 24033 | 12261 | 445 |
161432 | 161432 | 2020-05-20 | Prince George's | Maryland | 24033 | 12467 | 453 |
164461 | 164461 | 2020-05-21 | Prince George's | Maryland | 24033 | 12852 | 466 |
167497 | 167497 | 2020-05-22 | Prince George's | Maryland | 24033 | 13099 | 477 |
170534 | 170534 | 2020-05-23 | Prince George's | Maryland | 24033 | 13346 | 484 |
173576 | 173576 | 2020-05-24 | Prince George's | Maryland | 24033 | 14039 | 490 |
176619 | 176619 | 2020-05-25 | Prince George's | Maryland | 24033 | 14240 | 497 |
179663 | 179663 | 2020-05-26 | Prince George's | Maryland | 24033 | 14333 | 506 |
182709 | 182709 | 2020-05-27 | Prince George's | Maryland | 24033 | 14627 | 520 |
185764 | 185764 | 2020-05-28 | Prince George's | Maryland | 24033 | 15042 | 530 |
188822 | 188822 | 2020-05-29 | Prince George's | Maryland | 24033 | 15324 | 530 |
191886 | 191886 | 2020-05-30 | Prince George's | Maryland | 24033 | 15579 | 539 |
194954 | 194954 | 2020-05-31 | Prince George's | Maryland | 24033 | 15808 | 541 |
198025 | 198025 | 2020-06-01 | Prince George's | Maryland | 24033 | 15968 | 545 |
201097 | 201097 | 2020-06-02 | Prince George's | Maryland | 24033 | 16116 | 552 |
204174 | 204174 | 2020-06-03 | Prince George's | Maryland | 24033 | 16279 | 565 |
207255 | 207255 | 2020-06-04 | Prince George's | Maryland | 24033 | 16477 | 580 |
210336 | 210336 | 2020-06-05 | Prince George's | Maryland | 24033 | 16711 | 587 |
213420 | 213420 | 2020-06-06 | Prince George's | Maryland | 24033 | 16838 | 595 |
216508 | 216508 | 2020-06-07 | Prince George's | Maryland | 24033 | 16958 | 598 |
219600 | 219600 | 2020-06-08 | Prince George's | Maryland | 24033 | 17047 | 602 |
222695 | 222695 | 2020-06-09 | Prince George's | Maryland | 24033 | 17178 | 607 |
225791 | 225791 | 2020-06-10 | Prince George's | Maryland | 24033 | 17305 | 613 |
228893 | 228893 | 2020-06-11 | Prince George's | Maryland | 24033 | 17468 | 620 |
231997 | 231997 | 2020-06-12 | Prince George's | Maryland | 24033 | 17592 | 631 |
235102 | 235102 | 2020-06-13 | Prince George's | Maryland | 24033 | 17745 | 634 |
238209 | 238209 | 2020-06-14 | Prince George's | Maryland | 24033 | 17851 | 637 |
241318 | 241318 | 2020-06-15 | Prince George's | Maryland | 24033 | 17920 | 640 |
244429 | 244429 | 2020-06-16 | Prince George's | Maryland | 24033 | 17992 | 644 |
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);