names

26 rows where place_id = 597822

✎ 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
3629984 1904229 1904229 defendant Lane John husbandman 597822 597822 Lane, John, of Cote, husbandman 3
3707056 1928495 1928495 plaintiff Lane John gent 597822 597822 Lane, John, of Cote, gent 0
3813242 1962052 1962052 defendant Bluet Nicholas gent 597822 597822 Bluet, Nicholas, of Cote, gent 0
3908508 1993144 1993144 plaintiff Robertus Nicholas gent 597822 597822 Robertus, Nicholas, of Cote, gent 0
3964383 2012147 2012147 defendant Mors Robert husbandman 597822 597822 Mors, Robert, of Cote, husbandman 0
3965874 2012682 2012682 defendant Raynoldes Joan widow 597822 597822 Raynoldes, Joan, of Cote, widow 0
4182413 2089325 2089325 defendant Warman William husbandman 597822 597822 Warman, William, of Cote, or of Lyddyngton, husbandman 0
4541700 2213297 2213297 defendant Golst (illegible)   597822 597822 Golst, _, of Cote 3
4605141 2232773 2232773 plaintiff Andrewe Thomas   597822 597822 Andrewe, Thomas, of Cote 0
4623106 2238204 2238204 defendant Kyngeman John   597822 597822 Kyngeman, John, of Cote 0
4628664 2239889 2239889 defendant Saundres William   597822 597822 Saundres, William, of Cote 0
4649938 2246000 2246000 defendant Taillour John   597822 597822 Taillour, John, of Cote 0
4649939 2246000 2246000 defendant Kymber Alan   597822 597822 Kymber, Alan, of Cote 1
4687518 2261688 2261688 defendant Wattes Richard husbandman 597822 597822 Wattes, Richard, of Cote, husbandman 3
4687519 2261688 2261688 defendant fynmour John husbandman 597822 597822 fynmour, John, of Cote, husbandman 4
4690641 2262627 2262627 defendant Bridde Hugh husbandman 597822 597822 Bridde, Hugh, of Cote, husbandman 5
4690642 2262627 2262627 defendant Bridde John   597822 597822 Bridde, John, of Cote, shepherd 6
4690677 2262633 2262633 defendant Bridde Hugh husbandman 597822 597822 Bridde, Hugh, of Cote, husbandman 5
4690678 2262633 2262633 defendant Bridde John   597822 597822 Bridde, John, of Cote, shepherd 6
4693526 2263476 2263476 defendant Lokyer John yeoman 597822 597822 Lokyer, John, of Cote, yeoman 3
4808143 2298724 2298724 defendant Wyllys Thomas husbandman 597822 597822 Wyllys, Thomas, of Cote, husbandman 2
4820160 2302378 2302378 defendant Laver or Laner John husbandman 597822 597822 Laver or Laner, John, of Cote, husbandman 0
4876853 2319731 2319731 defendant Houchons John husbandman 597822 597822 Houchons, John, of Cote, husbandman 0
4895099 2325130 2325130 defendant Freman John husbandman 597822 597822 Freman, John, of Cote, husbandman 6
4919475 2332593 2332593 defendant Freman John husbandman 597822 597822 Freman, John, of Cote, husbandman 6
4945180 2340472 2340472 defendant Freman John husbandman 597822 597822 Freman, John, of Cote, husbandman 6

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