5 ms·
> Spreadsheets containing this accumulated data—last updated around the January 2017 presidential inauguration—constitute a treasure trove of political data and
by apeace 9y ago
> Spreadsheets containing this accumulated data—last updated around the January 2017 presidential inauguration—constitute a treasure trove of political data and modeled preferences used by the Trump campaign
Genuinely curious: can you really have 198 million rows in a spreadsheet?
- creepydata 9y agoIt's plural, spreadsheets. It could be thousands of separate files.
- apeace 9y agoGood catch. According to Microsoft[0], the max number of rows is 1,048,576. So I guess there must have been a couple hundred! [0] https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 https://support.office.com/en-us/article/Excel-specification...
- sp332 9y agoExcel limits each "sheet" to 1,048,576 rows, but there's no limit to how many sheets you can have in a single file. https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3?ui=en-US&rs=en-US&ad=US&fromAR=1 https://support.office.com/en-us/article/excel-specification...
- pc86 9y agoI used to work in this field (political consulting, the data around it, nothing terrible interesting on the tech front at the time though). It was most likely broken down by Congressional district.
- azinman2 9y agoIt’s provably a CSV not meant to be used by excel.
- nothis 9y agoCorrect: >Each file, formatted as a comma separated value (.csv), lists an internal, 32-character alphanumeric “RNC ID”—such as, for example, 530C2598-6EF4-4A56-9A7X-2FCA466FX2E2—used to uniquely identify every potential voter in the database.