names

56 rows where place_id = 771570

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4579690 2225134 2225134 defendant Dauns Robert   771570 771570 Dauns, Robert, of Groundesburgh 0
4583435 2226238 2226238 plaintiff Fre William   771570 771570 Fre, William, of Groundesburgh 0
4617265 2236412 2236412 defendant Danus Robert   771570 771570 Danus, Robert, of Groundesburgh 0
4666858 2255362 2255362 defendant Thurgerton Robert   771570 771570 Thurgerton, Robert, of Groundesburgh, parson 0
4667330 2255509 2255509 defendant Turnour Robert husbandman 771570 771570 Turnour, Robert, of Groundesburgh, husbandman 1
4667973 2255689 2255689 defendant Turnour Robert turner 771570 771570 Turnour, Robert, of Groundesburgh, turner 0
4669717 2256231 2256231 defendant Cantill John husbandman 771570 771570 Cantill, John, of Groundesburgh, husbandman 0
4669718 2256231 2256231 defendant Perevyll Simon   771570 771570 Perevyll, Simon, of Groundesburgh, fan maker 1
4691755 2262953 2262953 defendant Thurgerton Robert   771570 771570 Thurgerton, Robert, of Groundesburgh, parson 0
4691757 2262954 2262954 defendant Thurgerton Robert   771570 771570 Thurgerton, Robert, of Groundesburgh, parson 0
4692969 2263312 2263312 defendant Turnour Robert turner 771570 771570 Turnour, Robert, of Groundesburgh, turner 0
4695928 2264212 2264212 defendant Cook William clerk 771570 771570 Cook, William, of Groundesburgh, clerk 0
4701499 2265867 2265867 defendant Lane Peter weaver 771570 771570 Lane, Peter, of Groundesburgh, weaver 4
4713441 2269526 2269526 defendant Cantel John husbandman 771570 771570 Cantel, John, of Groundesburgh, husbandman 3
4715049 2270033 2270033 defendant Gosselyn Robert husbandman 771570 771570 Gosselyn, Robert, of Groundesburgh, husbandman 1
4798365 2295676 2295676 defendant Free William laborer 771570 771570 Free, William, of Groundesburgh, laborer 2
4798368 2295677 2295677 defendant Kentyng Thomas barber 771570 771570 Kentyng, Thomas, of Groundesburgh, barber 0
4818090 2301732 2301732 defendant Gosselyn John husbandman 771570 771570 Gosselyn, John, of Groundesburgh, husbandman 0
4884100 2321938 2321938 defendant Turnour Robert turner 771570 771570 Turnour, Robert, of Groundesburgh, turner 1
4886924 2322762 2322762 defendant Cook John yeoman 771570 771570 Cook, John, of Groundesburgh, yeoman 0
4902279 2327323 2327323 defendant Cook John yeoman 771570 771570 Cook, John, of Groundesburgh, yeoman 0
4937623 2338142 2338142 defendant Weylond Thomas husbandman 771570 771570 Weylond, Thomas, of Groundesburgh, husbandman 0
4946446 2340884 2340884 defendant Cook John yeoman 771570 771570 Cook, John, of Groundesburgh, yeoman 0
4951613 2342460 2342460 defendant Cook John butcher 771570 771570 Cook, John, of Groundesburgh, butcher 0
5010352 2359897 2359897 defendant Cook John   771570 771570 Cook, John, of Groundesburgh, laborer, son of John 0
5016383 2361685 2361685 defendant Page John husbandman 771570 771570 Page, John, of Groundesburgh, husbandman 0
5032447 2366374 2366374 defendant Rede John husbandman 771570 771570 Rede, John, of Groundesburgh, husbandman 0
5032448 2366374 2366374 defendant Catley Geoffrey husbandman 771570 771570 Catley, Geoffrey, of Groundesburgh, husbandman 1
5035941 2367368 2367368 defendant Weland John weaver 771570 771570 Weland, John, of Groundesburgh, weaver 3
5050249 2371696 2371696 defendant Weylond John husbandman 771570 771570 Weylond, John, of Groundesburgh, husbandman 0
5059653 2374452 2374452 defendant Gelour Thomas husbandman 771570 771570 Gelour, Thomas, of Groundesburgh, husbandman 4
5064380 2375892 2375892 defendant Weylond John yeoman 771570 771570 Weylond, John, of Groundesburgh, yeoman 9
5071852 2378075 2378075 defendant Penown John yeoman 771570 771570 Penown, John, of Groundesburgh, yeoman 0
5091108 2383795 2383795 defendant Gelour Thomas husbandman 771570 771570 Gelour, Thomas, of Groundesburgh, husbandman 0
5141708 2398687 2398687 defendant Dey Richard husbandman 771570 771570 Dey, Richard, of Groundesburgh, husbandman 1
5265253 2434891 2434891 defendant Wall John husbandman 771570 771570 Wall, John, of Groundesburgh, husbandman 0
5284199 2440398 2440398 defendant Weylond Robert husbandman 771570 771570 Weylond, Robert, of Groundesburgh, husbandman 0
5302674 2445778 2445778 defendant Penount John yeoman 771570 771570 Penount, John, of Groundesburgh, yeoman 1
5325170 2452615 2452615 defendant Heyward John husbandman 771570 771570 Heyward, John, of Groundesburgh, husbandman 0
5329852 2453996 2453996 defendant Cook John husbandman 771570 771570 Cook, John, of Groundesburgh, husbandman 1
5359534 2463015 2463015 defendant Walle John yeoman 771570 771570 Walle, John, of Groundesburgh, yeoman 0
5359535 2463015 2463015 defendant Lane Adam laborer 771570 771570 Lane, Adam, of Groundesburgh, laborer 1
5366875 2465294 2465294 defendant Burche Robert husbandman 771570 771570 Burche, Robert, of Groundesburgh, husbandman 0
5397481 2474358 2474358 defendant Penonn John husbandman 771570 771570 Penonn, John, of Groundesburgh, husbandman 0
5424654 2482337 2482337 defendant Penoun John husbandman 771570 771570 Penoun, John, of Groundesburgh, husbandman 0
5487527 2501165 2501165 defendant Baldewyn Robert husbandman 771570 771570 Baldewyn, Robert, of Groundesburgh, husbandman 0
5502125 2505587 2505587 defendant Baldewyn Robert husbandman 771570 771570 Baldewyn, Robert, of Groundesburgh, husbandman 0
5502126 2505587 2505587 defendant Baldewyn John husbandman 771570 771570 Baldewyn, John, of Groundesburgh, husbandman 1
5502127 2505587 2505587 defendant Baldewyn Thomas laborer 771570 771570 Baldewyn, Thomas, of Groundesburgh, laborer 2
5502129 2505588 2505588 defendant Baldewyn Robert husbandman 771570 771570 Baldewyn, Robert, of Groundesburgh, husbandman 0
5502130 2505588 2505588 defendant Baldewyn John husbandman 771570 771570 Baldewyn, John, of Groundesburgh, husbandman 1
5511100 2508311 2508311 defendant Walle Edmund yeoman 771570 771570 Walle, Edmund, of Groundesburgh, yeoman 2
5596084 2533689 2533689 defendant Bonde John yeoman 771570 771570 Bonde, John, of Groundesburgh, yeoman 0
5596086 2533689 2533689 defendant Manser John yeoman 771570 771570 Manser, John, of Groundesburgh, yeoman 2
5596089 2533690 2533690 defendant Bonde John yeoman 771570 771570 Bonde, John, of Groundesburgh, yeoman 0
5627203 2552474 2552474 defendant Cook William chaplain 771570 771570 Cook, William, of Groundesburgh, chaplain 0

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