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,144 rows where county = "Mercer" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 8

county 1

  • Mercer · 6,144 ✖
Link rowid date ▲ county state fips cases deaths
2500242 2500242 2022-05-13 Mercer Illinois 17131 4087 47
2500662 2500662 2022-05-13 Mercer Kentucky 21167 7401 106
2501142 2501142 2022-05-13 Mercer Missouri 29129 704 14
2501382 2501382 2022-05-13 Mercer New Jersey 34021 80988 1261
2501614 2501614 2022-05-13 Mercer North Dakota 38057 2577 24
2501697 2501697 2022-05-13 Mercer Ohio 39107 9715 144
2501889 2501889 2022-05-13 Mercer Pennsylvania 42085 23612 498
2502710 2502710 2022-05-13 Mercer West Virginia 54055 17177 266
2496984 2496984 2022-05-12 Mercer Illinois 17131 4078 47
2497404 2497404 2022-05-12 Mercer Kentucky 21167 7401 106
2497884 2497884 2022-05-12 Mercer Missouri 29129 704 14
2498124 2498124 2022-05-12 Mercer New Jersey 34021 80762 1261
2498356 2498356 2022-05-12 Mercer North Dakota 38057 2573 24
2498439 2498439 2022-05-12 Mercer Ohio 39107 9715 144
2498631 2498631 2022-05-12 Mercer Pennsylvania 42085 23612 498
2499452 2499452 2022-05-12 Mercer West Virginia 54055 17166 266
2493726 2493726 2022-05-11 Mercer Illinois 17131 4074 47
2494146 2494146 2022-05-11 Mercer Kentucky 21167 7401 106
2494626 2494626 2022-05-11 Mercer Missouri 29129 704 14
2494866 2494866 2022-05-11 Mercer New Jersey 34021 80363 1261
2495098 2495098 2022-05-11 Mercer North Dakota 38057 2573 24
2495181 2495181 2022-05-11 Mercer Ohio 39107 9699 144
2495373 2495373 2022-05-11 Mercer Pennsylvania 42085 23612 498
2496194 2496194 2022-05-11 Mercer West Virginia 54055 17154 265
2490468 2490468 2022-05-10 Mercer Illinois 17131 4066 47
2490888 2490888 2022-05-10 Mercer Kentucky 21167 7401 106
2491368 2491368 2022-05-10 Mercer Missouri 29129 704 14
2491608 2491608 2022-05-10 Mercer New Jersey 34021 80165 1261
2491840 2491840 2022-05-10 Mercer North Dakota 38057 2573 24
2491923 2491923 2022-05-10 Mercer Ohio 39107 9699 144
2492115 2492115 2022-05-10 Mercer Pennsylvania 42085 23500 498
2492936 2492936 2022-05-10 Mercer West Virginia 54055 17142 265
2487211 2487211 2022-05-09 Mercer Illinois 17131 4059 47
2487631 2487631 2022-05-09 Mercer Kentucky 21167 7401 106
2488110 2488110 2022-05-09 Mercer Missouri 29129 704 14
2488350 2488350 2022-05-09 Mercer New Jersey 34021 80000 1260
2488582 2488582 2022-05-09 Mercer North Dakota 38057 2573 24
2488665 2488665 2022-05-09 Mercer Ohio 39107 9699 144
2488857 2488857 2022-05-09 Mercer Pennsylvania 42085 23500 498
2489678 2489678 2022-05-09 Mercer West Virginia 54055 17142 265
2483953 2483953 2022-05-08 Mercer Illinois 17131 4056 47
2484373 2484373 2022-05-08 Mercer Kentucky 21167 7380 105
2484853 2484853 2022-05-08 Mercer Missouri 29129 704 14
2485093 2485093 2022-05-08 Mercer New Jersey 34021 79927 1260
2485325 2485325 2022-05-08 Mercer North Dakota 38057 2573 24
2485408 2485408 2022-05-08 Mercer Ohio 39107 9699 144
2485600 2485600 2022-05-08 Mercer Pennsylvania 42085 23500 498
2486421 2486421 2022-05-08 Mercer West Virginia 54055 17112 265
2480695 2480695 2022-05-07 Mercer Illinois 17131 4056 47
2481115 2481115 2022-05-07 Mercer Kentucky 21167 7380 105
2481595 2481595 2022-05-07 Mercer Missouri 29129 704 14
2481835 2481835 2022-05-07 Mercer New Jersey 34021 79789 1260
2482067 2482067 2022-05-07 Mercer North Dakota 38057 2573 24
2482150 2482150 2022-05-07 Mercer Ohio 39107 9699 144
2482342 2482342 2022-05-07 Mercer Pennsylvania 42085 23500 498
2483163 2483163 2022-05-07 Mercer West Virginia 54055 17112 265
2477437 2477437 2022-05-06 Mercer Illinois 17131 4056 47
2477857 2477857 2022-05-06 Mercer Kentucky 21167 7380 105
2478337 2478337 2022-05-06 Mercer Missouri 29129 704 14
2478577 2478577 2022-05-06 Mercer New Jersey 34021 79628 1260
2478809 2478809 2022-05-06 Mercer North Dakota 38057 2573 24
2478892 2478892 2022-05-06 Mercer Ohio 39107 9699 144
2479084 2479084 2022-05-06 Mercer Pennsylvania 42085 23500 498
2479905 2479905 2022-05-06 Mercer West Virginia 54055 17112 265
2474179 2474179 2022-05-05 Mercer Illinois 17131 4052 47
2474599 2474599 2022-05-05 Mercer Kentucky 21167 7380 105
2475079 2475079 2022-05-05 Mercer Missouri 29129 704 14
2475319 2475319 2022-05-05 Mercer New Jersey 34021 79447 1260
2475551 2475551 2022-05-05 Mercer North Dakota 38057 2571 24
2475634 2475634 2022-05-05 Mercer Ohio 39107 9699 144
2475826 2475826 2022-05-05 Mercer Pennsylvania 42085 23500 498
2476647 2476647 2022-05-05 Mercer West Virginia 54055 17108 265
2470922 2470922 2022-05-04 Mercer Illinois 17131 4052 47
2471342 2471342 2022-05-04 Mercer Kentucky 21167 7380 105
2471822 2471822 2022-05-04 Mercer Missouri 29129 697 13
2472062 2472062 2022-05-04 Mercer New Jersey 34021 79290 1259
2472294 2472294 2022-05-04 Mercer North Dakota 38057 2571 24
2472377 2472377 2022-05-04 Mercer Ohio 39107 9695 142
2472569 2472569 2022-05-04 Mercer Pennsylvania 42085 23500 498
2473389 2473389 2022-05-04 Mercer West Virginia 54055 17098 265
2467666 2467666 2022-05-03 Mercer Illinois 17131 4052 47
2468086 2468086 2022-05-03 Mercer Kentucky 21167 7380 105
2468566 2468566 2022-05-03 Mercer Missouri 29129 697 13
2468806 2468806 2022-05-03 Mercer New Jersey 34021 79160 1258
2469038 2469038 2022-05-03 Mercer North Dakota 38057 2571 24
2469121 2469121 2022-05-03 Mercer Ohio 39107 9695 142
2469313 2469313 2022-05-03 Mercer Pennsylvania 42085 23486 498
2470132 2470132 2022-05-03 Mercer West Virginia 54055 17093 265
2464411 2464411 2022-05-02 Mercer Illinois 17131 4046 47
2464831 2464831 2022-05-02 Mercer Kentucky 21167 7380 105
2465310 2465310 2022-05-02 Mercer Missouri 29129 697 13
2465550 2465550 2022-05-02 Mercer New Jersey 34021 79043 1258
2465782 2465782 2022-05-02 Mercer North Dakota 38057 2571 24
2465865 2465865 2022-05-02 Mercer Ohio 39107 9695 142
2466057 2466057 2022-05-02 Mercer Pennsylvania 42085 23476 498
2466876 2466876 2022-05-02 Mercer West Virginia 54055 17090 265
2461155 2461155 2022-05-01 Mercer Illinois 17131 4040 47
2461575 2461575 2022-05-01 Mercer Kentucky 21167 7360 105
2462055 2462055 2022-05-01 Mercer Missouri 29129 697 13
2462295 2462295 2022-05-01 Mercer New Jersey 34021 78874 1257

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