names

29 rows where place_id = 619144

✎ 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
3728375 1935119 1935119 defendant Deynes John husbandman 619144 619144 Deynes, John, of South Pykenham, husbandman 0
3761036 1945454 1945454 defendant Deyns John husbandman 619144 619144 Deyns, John, of South Pykenham, husbandman 2
3766827 1947290 1947290 defendant Bateman Thomas husbandman 619144 619144 Bateman, Thomas, of South Pykenham, husbandman 0
3801194 1958295 1958295 defendant Bateman Thomas husbandman 619144 619144 Bateman, Thomas, of South Pykenham, husbandman 0
3801198 1958296 1958296 defendant Bateman Thomas husbandman 619144 619144 Bateman, Thomas, of South Pykenham, husbandman 0
3818689 1963748 1963748 defendant Bateman Thomas husbandman 619144 619144 Bateman, Thomas, of South Pykenham, husbandman 0
3846544 1972476 1972476 defendant Basgate alias Busgar James miller 619144 619144 Basgate alias Busgar, James, of South Pykenham, miller 0
3900370 1990359 1990359 defendant Barbour John husbandman 619144 619144 Barbour, John, of South Pykenham, husbandman 3
3941775 2004262 2004262 defendant Barrett Thomas (legal representative) 619144 619144 Barrett, Thomas, of South Pykenham, husbandman, executor of 3
3941776 2004262 2004262 defendant Barrett William clerk 619144 619144 Barrett, William, of South Pykenham, clerk 4
3952652 2007997 2007997 defendant Rame or Raine Henry husbandman 619144 619144 Rame or Raine, Henry, of South Pykenham, husbandman 0
3955699 2009066 2009066 defendant Rame or Raine Henry yeoman 619144 619144 Rame or Raine, Henry, of South Pykenham, yeoman 0
4458710 2187768 2187768 defendant Lucas Alan   619144 619144 Lucas, Alan, of South Pykenham 0
4458711 2187768 2187768 defendant Lucas John   619144 619144 Lucas, John, of South Pykenham 1
4775463 2288322 2288322 defendant Dawys Robert yeoman 619144 619144 Dawys, Robert, of South Pykenham, yeoman 0
4783823 2290957 2290957 defendant Baret Thomas husbandman 619144 619144 Baret, Thomas, of South Pykenham, husbandman 1
5011162 2360118 2360118 defendant Thymyl Robert husbandman 619144 619144 Thymyl, Robert, of south Pykenham, husbandman 0
5029443 2365484 2365484 defendant Flap Walter husbandman 619144 619144 Flap, Walter, of South Pykenham, husbandman 2
5301087 2445278 2445278 defendant Baret James husbandman 619144 619144 Baret, James, of South Pykenham, husbandman 3
5347042 2459231 2459231 defendant Baret Richard (legal representative) 619144 619144 Baret, Richard, of South Pykenham, executors of 0
5347043 2459231 2459231 defendant Tuyston alias Twetylston John husbandman 619144 619144 (Tuyston alias Twetylston, John, of South Pykenham, husbandman 1
5403412 2476049 2476049 defendant Bettys William   619144 619144 Bettys, William, of South Pykenham 0
5416464 2479844 2479844 defendant Bettys William husbandman 619144 619144 Bettys, William, of South Pykenham, husbandman 0
5490622 2502086 2502086 defendant Baret Richard husbandman 619144 619144 Baret, Richard, of South Pykenham, husbandman 1
5494574 2503263 2503263 defendant Doweket John husbandman 619144 619144 Doweket, John, of South Pykenham, husbandman 1
5504829 2506431 2506431 plaintiff Barton John clerk 619144 619144 Barton, John, of South Pykenham, clerk 0
5504832 2506432 2506432 plaintiff Barton John clerk 619144 619144 Barton, John, of South Pykenham, clerk 0
5536810 2515999 2515999 defendant Gateman John, junior husbandman 619144 619144 Gateman, John, junior, of South Pykenham, husbandman 0
5633463 2554464 2554464 defendant Pakenham Andrew esq 619144 619144 Pakenham, Andrew, of South Pykenham, esq 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);