names

35 rows where place_id = 646998

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3893891 1988180 1988180 plaintiff Pycher John chaplain 646998 646998 Pycher, John, of Aldermaston, chaplain 0
3908137 1993019 1993019 plaintiff Pycher John chaplain 646998 646998 Pycher, John, of Aldermaston, chaplain 0
4062585 2046911 2046911 plaintiff Foster Humphrey   646998 646998 Foster, Humphrey, of Aldermaston, esq, his brother 1
4062588 2046912 2046912 plaintiff Foster Humphrey   646998 646998 Foster, Humphrey, of Aldermaston, esq, his brother 1
4416717 2170095 2170095 defendant Palmere John   646998 646998 Palmere, John, of Aldermaston 1
4440950 2182090 2182090 defendant Halle John   646998 646998 Halle, John, of Aldermaston 8
4440953 2182090 2182090 defendant Coke John   646998 646998 Coke, John, of Aldermaston 11
4484362 2195809 2195809 defendant Smyth John   646998 646998 Smyth, John, of Aldermaston 1
4520126 2206629 2206629 defendant Hyvewode Walter   646998 646998 Hyvewode, Walter, of Aldermaston 0
4538171 2212224 2212224 defendant Heghwey Alan   646998 646998 Heghwey, Alan, of Aldermaston 0
4549220 2215697 2215697 defendant Hyde John fuller 646998 646998 Hyde, John, of Aldermaston, fuller 1
4557576 2218304 2218304 defendant Litell William   646998 646998 Litell, William, of Aldermaston 0
4643381 2244170 2244170 defendant Cordewaner Walter   646998 646998 Cordewaner, Walter, of Aldermaston 1
4676013 2258108 2258108 defendant Lyttell William fishmonger 646998 646998 Lyttell, William, of Aldermaston, fishmonger 0
4697793 2264807 2264807 defendant Upton Walter   646998 646998 Upton, Walter, of Aldermaston, shoe maker 0
4697795 2264808 2264808 defendant Upton Walter   646998 646998 Upton, Walter, of Aldermaston, shoe maker 0
4730566 2274758 2274758 defendant Ergaston Thomas   646998 646998 Ergaston, Thomas, of Aldermaston, Berks, carter, servant of John 4
4775555 2288347 2288347 defendant Kirkeby William chapman 646998 646998 Kirkeby, William, of Aldermaston, chapman 0
4807099 2298419 2298419 defendant Dalamare Robert gent 646998 646998 Dalamare, Robert, of Aldermaston, gent 0
4807100 2298419 2298419 defendant Coke John yeoman 646998 646998 Coke, John, of Aldermaston, yeoman 1
4813451 2300320 2300320 defendant de la Mare Robert gent 646998 646998 de la Mare, Robert, of Aldermaston, gent 0
4813452 2300320 2300320 defendant Cook John   646998 646998 Cook, John, of Aldermaston, servant of Robert 1
4813454 2300321 2300321 defendant de la Mare Robert gent 646998 646998 de la Mare, Robert, of Aldermaston, gent 0
4813455 2300321 2300321 defendant Cook John   646998 646998 Cook, John, of Aldermaston, servant of Robert 1
4822224 2303031 2303031 defendant Dalamare Robert gent 646998 646998 Dalamare, Robert, of Aldermaston, gent 0
4822225 2303031 2303031 defendant Godefrend John yeoman 646998 646998 with Godefrend, John, of Aldermaston, yeoman 1
4825278 2303948 2303948 defendant de la Mare Robert gent 646998 646998 de la Mare, Robert, of Aldermaston, gent 0
4825279 2303948 2303948 defendant Cook John   646998 646998 Cook, John, of Aldermaston, servant of Robert 1
5021108 2363069 2363069 defendant Assheley John husbandman 646998 646998 Assheley, John, of Aldermaston, husbandman 0
5021109 2363069 2363069 defendant Este Thomas husbandman 646998 646998 Este, Thomas, of Aldermaston, husbandman 1
5042436 2369345 2369345 defendant Assheley Thomas farmer 646998 646998 Assheley, Thomas, of Aldermaston, farmer 0
5042440 2369346 2369346 defendant Assheley Thomas farmer 646998 646998 with Assheley, Thomas, of Aldermaston, farmer 1
5244759 2428638 2428638 defendant Bocher John husbandman 646998 646998 Bocher, John, of Aldermaston, husbandman 2
5418198 2480368 2480368 defendant Hynde John yeoman 646998 646998 Hynde, John, of Aldermaston, yeoman 2
5435746 2485631 2485631 defendant Hynde John yeoman 646998 646998 Hynde, John, of Aldermaston, yeoman 2

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