names

48 rows where place_id = 592979

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3609710 1870705 1870705 defendant Mylys Nicholas tailor 592979 592979 Mylys, Nicholas, of Tatyngston, tailor 0
3609711 1870705 1870705 defendant Mannyng John husbandman 592979 592979 Mannyng, John, of Tatyngston, husbandman 1
3854216 1974956 1974956 defendant Frelowe John yeoman 592979 592979 Frelowe, John, of Tatyngston, yeoman 1
3868575 1979728 1979728 defendant Frelowe John yeoman 592979 592979 Frelowe, John, of Tatyngston, yeoman 0
3868578 1979729 1979729 defendant Frelowe John yeoman 592979 592979 Frelowe, John, of Tatyngston, yeoman 0
4431805 2174722 2174722 defendant Caperon John   592979 592979 Caperon, John, of Tatyngston, parson 0
4431806 2174722 2174722 defendant White Henry   592979 592979 White, Henry, of Tatyngston 1
4434082 2175420 2175420 defendant Caperon John   592979 592979 Caperon, John, of Tatyngston, parson 0
4434083 2175420 2175420 defendant White Henry   592979 592979 White, Henry, of Tatyngston 1
4541263 2213164 2213164 defendant Reynold William   592979 592979 Reynold, William, of Tatyngston 1
4634460 2241626 2241626 plaintiff Wolffreston Elizabeth   592979 592979 Wolffreston, Elizabeth, of Tatyngston, formerly wife of Roger 0
4660599 2249142 2249142 defendant Saundres Robert fuller 592979 592979 Saundres, Robert, of Tatyngston, fuller 1
4726310 2273510 2273510 defendant Andrewe William fuller 592979 592979 Andrewe, William, of Tatyngston, fuller 2
4803129 2297169 2297169 plaintiff Baldewyn Richard   592979 592979 Baldewyn, Richard, of Tatyngston 0
4803135 2297172 2297172 plaintiff Baldwyn Richard   592979 592979 Baldwyn, Richard, of Tatyngston 0
4809124 2299029 2299029 defendant Peteman John fuller 592979 592979 Peteman, John, of Tatyngston, fuller 0
4873370 2318626 2318626 defendant Petman John yeoman 592979 592979 Petman, John, of Tatyngston, yeoman 0
4915249 2331275 2331275 defendant Fistman John yeoman 592979 592979 Fistman, John, of Tatyngston, yeoman 1
4994218 2355145 2355145 defendant Petman Joh fuller 592979 592979 Petman, Joh, of Tatyngston, fuller 4
4994966 2355353 2355353 defendant Deynes John, sen yeoman 592979 592979 Deynes, John, sen, of Tatyngston, yeoman 0
5019571 2362609 2362609 defendant Baldwyn Alice widow 592979 592979 Baldwyn, Alice, of Tatyngston, widow 1
5026107 2364532 2364532 defendant Andrewe Thomas fuller 592979 592979 Andrewe, Thomas, of Tatyngston, fuller 1
5056099 2373397 2373397 defendant Arnold William yeoman 592979 592979 Arnold, William, of Tatyngston, yeoman 0
5064162 2375821 2375821 defendant Chesfeld William husbandman 592979 592979 Chesfeld, William, of Tatyngston, husbandman 4
5096783 2385490 2385490 defendant Andrewe Henry fuller 592979 592979 Andrewe, Henry, of Tatyngston, fuller 1
5096784 2385490 2385490 defendant Casfeld William barber 592979 592979 Casfeld, William, of Tatyngston, barber 2
5101141 2386748 2386748 plaintiff Arnold Roger (legal representative) 592979 592979 Arnold, Roger, of Tatyngston, executors of 0
5101146 2386749 2386749 plaintiff Arnold Roger (legal representative) 592979 592979 Arnold, Roger, of Tatyngston, executors of 0
5104612 2387784 2387784 defendant Arnold Thomas fuller 592979 592979 Arnold, Thomas, of Tatyngston, fuller 3
5106626 2388365 2388365 defendant Sourby Margaret gentlewoman 592979 592979 Sourby, Margaret, of Tatyngston, gentlewoman 0
5107094 2388503 2388503 defendant Sourby Margaret gentlewoman 592979 592979 Sourby, Margaret, of Tatyngston, gentlewoman 0
5109222 2389122 2389122 defendant Sourby Margaret gentlewoman 592979 592979 Sourby, Margaret, of Tatyngston, gentlewoman 0
5109224 2389123 2389123 defendant Sourby Margaret gentlewoman 592979 592979 Sourby, Margaret, of Tatyngston, gentlewoman 0
5133746 2396362 2396362 defendant Arnold John fuller 592979 592979 Arnold, John, of Tatyngston, fuller 0
5133747 2396362 2396362 defendant Arnold William fuller 592979 592979 Arnold William, of Tatyngston, fuller 1
5143735 2399299 2399299 defendant Mors Roger husbandman 592979 592979 Mors, Roger, of Tatyngston, husbandman 0
5235470 2425952 2425952 defendant Fulthorp Thomas esq 592979 592979 Fulthorp, Thomas, of Tatyngston, esq 0
5309729 2447946 2447946 defendant Pod John laborer 592979 592979 Pod, John, of Tatyngston, laborer 1
5309730 2447946 2447946 defendant Pod Robert laborer 592979 592979 Pod, Robert, of Tatyngston, laborer 2
5335530 2455699 2455699 defendant Arnold Thomas (legal representative) 592979 592979 Arnold, Thomas, of Tatyngston, fuller, administratrix of 3
5335531 2455699 2455699 defendant Arnold Dulcia widow 592979 592979 Arnold, Dulcia, of Tatyngston, widow 4
5335536 2455700 2455700 defendant Arnold Thomas (legal representative) 592979 592979 Arnold, Thomas, of Tatyngston, fuller, administratrix of 3
5335537 2455700 2455700 defendant Arnold Dulcia widow 592979 592979 Arnold, Dulcia, of Tatyngston, widow 4
5397498 2474358 2474358 defendant Norffolk Thomas laborer 592979 592979 Norffolk, Thomas, of Tatyngston, laborer 17
5397499 2474358 2474358 defendant Podde or Codde Robert husbandman 592979 592979 Podde or Codde, Robert, of Tatyngston, husbandman 18
5424671 2482337 2482337 defendant Norfolk Thomas laborer 592979 592979 Norfolk, Thomas, of Tatyngston, laborer 17
5424672 2482337 2482337 defendant Podde Robert husbandman 592979 592979 Podde, Robert, of Tatyngston, husbandman 18
5443399 2487938 2487938 defendant Podde Robert yeoman 592979 592979 Podde, Robert, of Tatyngston, yeoman 16

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