names

44 rows where place_id = 609529

✎ 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
3678868 1919457 1919457 defendant Partrich Thomas husbandman 609529 609529 Partrich, Thomas, of Ightham, husbandman 0
3683303 1920901 1920901 defendant Drope John husbandman 609529 609529 Drope, John, of Ightham, husbandman 0
3927545 1999554 1999554 defendant Fuller John husbandman 609529 609529 Fuller, John, of Ightham, husbandman 1
4021956 2032581 2032581 plaintiff Allyn Christopher   609529 609529 Allyn, Christopher, of Ightham, knight 0
4728452 2274131 2274131 defendant Smyth John smith 609529 609529 Smyth, John, of Ightham, smith 0
4742205 2278211 2278211 defendant Fabyan John husbandman 609529 609529 Fabyan, John, of Ightham, husbandman 0
4752777 2281268 2281268 defendant Abselen Robert husbandman 609529 609529 Abselen, Robert, of Ightham, husbandman 1
5003440 2357902 2357902 defendant Furmeger William husbandman 609529 609529 Furmeger, William, of Ightham, husbandman 1
5021194 2363098 2363098 defendant Sawyer John husbandman 609529 609529 Sawyer, John, of Ightham, husbandman 2
5113931 2390462 2390462 defendant Ivet Lawrence husbandman 609529 609529 Ivet, Lawrence, of Ightham, husbandman 0
5149493 2400981 2400981 defendant Berne Thomas husbandman 609529 609529 Berne, Thomas, of Ightham, husbandman 0
5162071 2404640 2404640 defendant Smyth John smith 609529 609529 Smyth, John, of Ightham, smith 3
5168418 2406478 2406478 defendant Berne Thomas husbandman 609529 609529 Berne, Thomas, of Ightham, husbandman 0
5176295 2408756 2408756 defendant Smyth John smith 609529 609529 Smyth, John, of Ightham, smith 3
5350299 2460213 2460213 defendant Pelsotte or Pelfotte Thomas   609529 609529 Pelsotte or Pelfotte, Thomas, of Ightham, "repyer" 2
5378503 2468862 2468862 defendant Wymbyll William thatcher 609529 609529 Wymbyll, William, of Ightham, thatcher 0
5380963 2469612 2469612 defendant Hesilhurst Henry   609529 609529 Hesilhurst, Henry, of Ightham 1
5387071 2471371 2471371 defendant Heshurst Henry smith 609529 609529 Heshurst, Henry, of Ightham, smith 1
5389703 2472118 2472118 defendant Sorell William   609529 609529 Sorell, William, of Ightham, payle maker 1
5391997 2472790 2472790 defendant Fuller Walter repyer or fish seller 609529 609529 Fuller, Walter, of Ightham, repyer or fish seller 3
5397848 2474456 2474456 defendant Partriche Lawrence husbandman 609529 609529 Partriche, Lawrence, of Ightham, husbandman 0
5405012 2476512 2476512 defendant Fuller Walter repyer or one who carries fish inland to sell 609529 609529 Fuller, Walter, of Ightham, repyer or one who carries fish inland to sell 2
5412480 2478678 2478678 defendant Hesylhurst Henry smith 609529 609529 Hesylhurst, Henry, of Ightham, smith 1
5427278 2483102 2483102 defendant Hesylhurst Henry smith 609529 609529 Hesylhurst, Henry, of Ightham, smith 1
5431203 2484277 2484277 defendant None John husbandman 609529 609529 None, John, of Ightham, husbandman 0
5431204 2484277 2484277 defendant None Robert laborer 609529 609529 None, Robert, of Ightham, laborer 1
5431205 2484277 2484277 defendant Thrope John husbandman 609529 609529 Thrope, John, of Ightham, husbandman 2
5443642 2488018 2488018 defendant Wandover Richard laborer 609529 609529 Wandover, Richard, of Ightham, laborer 1
5445107 2488424 2488424 defendant Hesilhurst Henry smith 609529 609529 Hesilhurst, Henry, of Ightham, smith 1
5445132 2488432 2488432 defendant Helihirst Henry smith 609529 609529 Helihirst, Henry, of Ightham, smith 1
5448263 2489373 2489373 defendant James William husbandman 609529 609529 James, William, of Ightham, husbandman 0
5448264 2489373 2489373 defendant Hasylherst Henry smith 609529 609529 Hasylherst, Henry, of Ightham, smith 1
5457780 2492222 2492222 defendant Hesilhurst Henry smith 609529 609529 Hesilhurst, Henry, of Ightham, smith 1
5457783 2492223 2492223 defendant Hesilhurst Henry smith 609529 609529 Hesilhurst, Henry, of Ightham, smith 1
5460611 2493119 2493119 defendant James William husbandman 609529 609529 James, William, of Ightham, husbandman 0
5460612 2493119 2493119 defendant Hasylherst Henry smith 609529 609529 Hasylherst, Henry, of Ightham, smith 1
5460614 2493120 2493120 defendant James William husbandman 609529 609529 James, William, of Ightham, husbandman 0
5460615 2493120 2493120 defendant Hasylherst Henry smith 609529 609529 Hasylherst, Henry, of Ightham, smith 1
5467111 2495109 2495109 defendant Pelfote Thomas   609529 609529 Pelfote, Thomas, of Ightham, inland fish seller 1
5469611 2495829 2495829 defendant Hesylhurst Henry smith 609529 609529 Hesylhurst, Henry, of Ightham, smith 1
5469614 2495830 2495830 defendant Hesilhurst Henry smith 609529 609529 Hesilhurst, Henry, of Ightham, smith 1
5469617 2495831 2495831 defendant Hesulhurst Henry smith 609529 609529 Hesulhurst, Henry, of Ightham, smith 1
5478398 2498567 2498567 defendant Pelfote Thomas   609529 609529 Pelfote, Thomas, of Ightham, "repyer" 1
5633389 2554437 2554437 defendant Smyth Lawrence laborer 609529 609529 Smyth, Lawrence, of Ightham, laborer 1

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