names

17 rows where place_id = 665940

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3978961 2017229 2017229 defendant Pyle Thomas husbandman 665940 665940 Pyle, Thomas, of Thirne, husbandman 0
4180827 2088772 2088772 defendant Smyth Francis gent 665940 665940 Smyth, Francis, of Thirne, gent 0
4289727 2126388 2126388 defendant Andrewes William   665940 665940 Andrewes, William, of Thirne husbandman 1
4329411 2140147 2140147 defendant Fox George yeoman 665940 665940 Fox, George, of Thirne, yeoman 0
4447842 2184254 2184254 defendant Ferier John   665940 665940 Ferier, John, of Thirne 3
4555636 2217690 2217690 defendant Aleyne John   665940 665940 Aleyne, John, of Thirne 2
4776674 2288695 2288695 defendant Williamson Alan husbandman 665940 665940 Williamson, Alan, of Thirne, husbandman 2
4810601 2299464 2299464 defendant Barker Thomas husbandman 665940 665940 Barker, Thomas, of Thirne, husbandman 2
4810718 2299473 2299473 defendant Baker Thomas husbandman 665940 665940 Baker, Thomas, of Thirne, husbandman 2
5112963 2390186 2390186 defendant Davy Geoffrey husbandman 665940 665940 Davy, Geoffrey, of Thirne, husbandman 2
5118141 2391740 2391740 plaintiff Rede William   665940 665940 Rede, William, of Thirne 0
5131694 2395753 2395753 defendant Reyna-- William clerk 665940 665940 Reyna--, William, of Thirne, clerk 4
5154731 2402537 2402537 defendant Rede William husbandman 665940 665940 Rede, William, of Thirne, husbandman 0
5171674 2407435 2407435 defendant Rede William husbandman 665940 665940 Rede, William, of Thirne, husbandman 0
5206885 2417748 2417748 defendant Rede William husbandman 665940 665940 Rede, William, of Thirne, husbandman 0
5208063 2418090 2418090 defendant Reed William yeoman 665940 665940 Reed, William, of Thirne, yeoman 1
5260034 2433259 2433259 defendant Rede John laborer 665940 665940 Rede, John, of Thirne, laborer 3

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);