ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

6,231 rows where county = "Randolph" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 8

fips 8

county 1

  • Randolph · 6,231 ✖
Link rowid date ▲ county state fips cases deaths
2499630 2499630 2022-05-13 Randolph Alabama 1111 5085 75
2499746 2499746 2022-05-13 Randolph Arkansas 5121 5217 89
2500085 2500085 2022-05-13 Randolph Georgia 13243 1490 48
2500255 2500255 2022-05-13 Randolph Illinois 17157 10567 132
2500347 2500347 2022-05-13 Randolph Indiana 18135 5913 148
2501165 2501165 2022-05-13 Randolph Missouri 29175 6058 103
2501561 2501561 2022-05-13 Randolph North Carolina 37151 35874 444
2502724 2502724 2022-05-13 Randolph West Virginia 54083 9533 89
2496372 2496372 2022-05-12 Randolph Alabama 1111 5085 75
2496488 2496488 2022-05-12 Randolph Arkansas 5121 5215 89
2496827 2496827 2022-05-12 Randolph Georgia 13243 1490 48
2496997 2496997 2022-05-12 Randolph Illinois 17157 10555 132
2497089 2497089 2022-05-12 Randolph Indiana 18135 5912 148
2497907 2497907 2022-05-12 Randolph Missouri 29175 6049 103
2498303 2498303 2022-05-12 Randolph North Carolina 37151 35874 444
2499466 2499466 2022-05-12 Randolph West Virginia 54083 9526 89
2493114 2493114 2022-05-11 Randolph Alabama 1111 5089 75
2493230 2493230 2022-05-11 Randolph Arkansas 5121 5213 89
2493569 2493569 2022-05-11 Randolph Georgia 13243 1490 48
2493739 2493739 2022-05-11 Randolph Illinois 17157 10554 132
2493831 2493831 2022-05-11 Randolph Indiana 18135 5912 148
2494649 2494649 2022-05-11 Randolph Missouri 29175 6049 103
2495045 2495045 2022-05-11 Randolph North Carolina 37151 35874 444
2496208 2496208 2022-05-11 Randolph West Virginia 54083 9512 89
2489856 2489856 2022-05-10 Randolph Alabama 1111 5092 75
2489972 2489972 2022-05-10 Randolph Arkansas 5121 5210 89
2490311 2490311 2022-05-10 Randolph Georgia 13243 1490 48
2490481 2490481 2022-05-10 Randolph Illinois 17157 10551 132
2490573 2490573 2022-05-10 Randolph Indiana 18135 5911 148
2491391 2491391 2022-05-10 Randolph Missouri 29175 6049 103
2491787 2491787 2022-05-10 Randolph North Carolina 37151 35737 444
2492950 2492950 2022-05-10 Randolph West Virginia 54083 9503 89
2486599 2486599 2022-05-09 Randolph Alabama 1111 5090 75
2486715 2486715 2022-05-09 Randolph Arkansas 5121 5208 89
2487054 2487054 2022-05-09 Randolph Georgia 13243 1490 48
2487224 2487224 2022-05-09 Randolph Illinois 17157 10547 132
2487316 2487316 2022-05-09 Randolph Indiana 18135 5911 148
2488133 2488133 2022-05-09 Randolph Missouri 29175 6049 103
2488529 2488529 2022-05-09 Randolph North Carolina 37151 35737 444
2489692 2489692 2022-05-09 Randolph West Virginia 54083 9503 89
2483341 2483341 2022-05-08 Randolph Alabama 1111 5089 75
2483457 2483457 2022-05-08 Randolph Arkansas 5121 5208 89
2483796 2483796 2022-05-08 Randolph Georgia 13243 1490 48
2483966 2483966 2022-05-08 Randolph Illinois 17157 10540 132
2484058 2484058 2022-05-08 Randolph Indiana 18135 5912 148
2484876 2484876 2022-05-08 Randolph Missouri 29175 6049 103
2485272 2485272 2022-05-08 Randolph North Carolina 37151 35737 444
2486435 2486435 2022-05-08 Randolph West Virginia 54083 9486 89
2480083 2480083 2022-05-07 Randolph Alabama 1111 5089 75
2480199 2480199 2022-05-07 Randolph Arkansas 5121 5205 89
2480538 2480538 2022-05-07 Randolph Georgia 13243 1490 48
2480708 2480708 2022-05-07 Randolph Illinois 17157 10540 132
2480800 2480800 2022-05-07 Randolph Indiana 18135 5912 148
2481618 2481618 2022-05-07 Randolph Missouri 29175 6049 103
2482014 2482014 2022-05-07 Randolph North Carolina 37151 35737 444
2483177 2483177 2022-05-07 Randolph West Virginia 54083 9486 89
2476825 2476825 2022-05-06 Randolph Alabama 1111 5089 75
2476941 2476941 2022-05-06 Randolph Arkansas 5121 5205 89
2477280 2477280 2022-05-06 Randolph Georgia 13243 1490 48
2477450 2477450 2022-05-06 Randolph Illinois 17157 10540 132
2477542 2477542 2022-05-06 Randolph Indiana 18135 5912 148
2478360 2478360 2022-05-06 Randolph Missouri 29175 6049 103
2478756 2478756 2022-05-06 Randolph North Carolina 37151 35737 444
2479919 2479919 2022-05-06 Randolph West Virginia 54083 9486 89
2473567 2473567 2022-05-05 Randolph Alabama 1111 5088 74
2473683 2473683 2022-05-05 Randolph Arkansas 5121 5198 89
2474022 2474022 2022-05-05 Randolph Georgia 13243 1490 48
2474192 2474192 2022-05-05 Randolph Illinois 17157 10533 132
2474284 2474284 2022-05-05 Randolph Indiana 18135 5912 148
2475102 2475102 2022-05-05 Randolph Missouri 29175 6033 103
2475498 2475498 2022-05-05 Randolph North Carolina 37151 35737 444
2476661 2476661 2022-05-05 Randolph West Virginia 54083 9479 89
2470310 2470310 2022-05-04 Randolph Alabama 1111 5085 74
2470426 2470426 2022-05-04 Randolph Arkansas 5121 5196 89
2470765 2470765 2022-05-04 Randolph Georgia 13243 1490 48
2470935 2470935 2022-05-04 Randolph Illinois 17157 10522 132
2471027 2471027 2022-05-04 Randolph Indiana 18135 5912 148
2471845 2471845 2022-05-04 Randolph Missouri 29175 6013 102
2472241 2472241 2022-05-04 Randolph North Carolina 37151 35737 444
2473403 2473403 2022-05-04 Randolph West Virginia 54083 9477 89
2467054 2467054 2022-05-03 Randolph Alabama 1111 5085 74
2467170 2467170 2022-05-03 Randolph Arkansas 5121 5195 89
2467509 2467509 2022-05-03 Randolph Georgia 13243 1487 48
2467679 2467679 2022-05-03 Randolph Illinois 17157 10518 131
2467771 2467771 2022-05-03 Randolph Indiana 18135 5912 148
2468589 2468589 2022-05-03 Randolph Missouri 29175 6013 102
2468985 2468985 2022-05-03 Randolph North Carolina 37151 35612 404
2470146 2470146 2022-05-03 Randolph West Virginia 54083 9472 89
2463799 2463799 2022-05-02 Randolph Alabama 1111 5085 74
2463915 2463915 2022-05-02 Randolph Arkansas 5121 5194 89
2464254 2464254 2022-05-02 Randolph Georgia 13243 1487 48
2464424 2464424 2022-05-02 Randolph Illinois 17157 10509 131
2464516 2464516 2022-05-02 Randolph Indiana 18135 5912 148
2465333 2465333 2022-05-02 Randolph Missouri 29175 6013 102
2465729 2465729 2022-05-02 Randolph North Carolina 37151 35612 404
2466890 2466890 2022-05-02 Randolph West Virginia 54083 9467 89
2460543 2460543 2022-05-01 Randolph Alabama 1111 5085 74
2460659 2460659 2022-05-01 Randolph Arkansas 5121 5194 89
2460998 2460998 2022-05-01 Randolph Georgia 13243 1487 48
2461168 2461168 2022-05-01 Randolph Illinois 17157 10506 131

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);