names

31 rows where place_id = 605869

✎ 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
3663209 1914414 1914414 defendant Peperer John husbandman 605869 605869 Peperer, John, of Alwardbury, husbandman 0
4571941 2222799 2222799 defendant Pobel Thomas   605869 605869 Pobel, Thomas, of Alwardbury 2
4571942 2222799 2222799 defendant Canon Tholomen   605869 605869 Canon, Tholomen, of Alwardbury 3
4603342 2232241 2232241 defendant Cuollis John   605869 605869 Cuollis, John, of Alwardbury 2
4699109 2265186 2265186 defendant Rolleg John tiler 605869 605869 Rolleg, John, of Alwardbury, tiler 1
4753894 2281597 2281597 defendant Ambros Richard forester 605869 605869 Ambros, Richard, of Alwardbury, forester 0
4808117 2298714 2298714 defendant Arnald Thomas clerk 605869 605869 Arnald, Thomas, of Alwardbury, clerk 0
4826603 2304355 2304355 defendant Stepehenes John   605869 605869 Stepehenes, John, of Alwardbury, tile maker 2
4886260 2322564 2322564 defendant Bolton John husbandman 605869 605869 Bolton, John, of Alwardbury, husbandman 4
4886261 2322564 2322564 defendant Clerk John tiler 605869 605869 Clerk, John, of Alwardbury, tiler 5
4891596 2324111 2324111 defendant Beston John yeoman 605869 605869 Beston, John, of Alwardbury, yeoman 1
4901522 2327080 2327080 defendant Pepard John, junior husbandman 605869 605869 Pepard, John, junior, of Alwardbury, husbandman 0
4953152 2342907 2342907 defendant Bolton John husbandman 605869 605869 Bolton, John, of Alwardbury, husbandman 2
4989089 2353673 2353673 defendant Scoterigge William husbandman 605869 605869 Scoterigge, William, of Alwardbury, husbandman 3
5016195 2361623 2361623 defendant Scoterigge William husbandman 605869 605869 Scoterigge, William, of Alwardbury, husbandman 1
5113704 2390402 2390402 defendant Londe John husbandman 605869 605869 Londe, John, of Alwardbury, husbandman 0
5113705 2390402 2390402 defendant Danyell John laborer 605869 605869 Danyell, John, of Alwardbury, laborer 1
5159555 2403911 2403911 defendant Crokker John yeoman 605869 605869 Crokker, John, of Alwardbury, yeoman 0
5174655 2408286 2408286 defendant Crokker John yeoman 605869 605869 Crokker, John, of Alwardbury, yeoman 0
5248614 2429718 2429718 defendant Spencer John husbandman 605869 605869 Spencer, John, of Alwardbury, husbandman 0
5248615 2429718 2429718 defendant Stephens William husbandman 605869 605869 Stephens, William, of Alwardbury, husbandman 1
5272576 2437053 2437053 defendant Spygernell Philip husbandman 605869 605869 Spygernell, Philip, of Alwardbury, husbandman 0
5272577 2437053 2437053 defendant Ho--kyn John husbandman 605869 605869 Ho--kyn, John, of Alwardbury, husbandman 1
5272578 2437053 2437053 defendant Clerke John tiler 605869 605869 Clerke, John, of Alwardbury, tiler 2
5440088 2486939 2486939 defendant Haughton Christopher yeoman 605869 605869 Haughton, Christopher, of Alwardbury, yeoman 0
5440089 2486939 2486939 defendant Falley John husbandman 605869 605869 Falley, John, of Alwardbury, husbandman 1
5453335 2490881 2490881 defendant Homy_ Christopher yeoman 605869 605869 Homy_, Christopher, of Alwardbury, yeoman 0
5453336 2490881 2490881 defendant Fawey John husbandman 605869 605869 Fawey, John, of Alwardbury, husbandman 1
5585182 2530434 2530434 defendant Lavyngton Edith widow 605869 605869 Lavyngton, Edith, of Alwardbury, widow 1
5613668 2548051 2548051 plaintiff Davyd Richard   605869 605869 Davyd, Richard, of Alwardbury 0
5636765 2555442 2555442 defendant Baret John husbandman 605869 605869 Baret, John, of Alwardbury, husbandman 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);