names

39 rows where place_id = 607908

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3671403 1917035 1917035 defendant Childe John wheeler 607908 607908 Childe, John, of Bledlowe, Bucks, wheeler 0
3764022 1946391 1946391 defendant Laurence alias Smyth John husbandman 607908 607908 Laurence alias Smyth, John, of Bledlowe, Bucks, husbandman 0
4030378 2035518 2035518 plaintiff Easte Edward gent 607908 607908 Easte, Edward, of Bledlowe, Bucks, gent 0
4231411 2106487 2106487 defendant Francklyn John yeoman 607908 607908 Francklyn, John, of Bledlowe, Bucks, yeoman 0
4273664 2120737 2120737 defendant Francklyn John yeoman 607908 607908 Francklyn, John, of Bledlowe, Bucks, yeoman 0
4740149 2277637 2277637 defendant Coltman John husbandman 607908 607908 Coltman, John, of Bledlowe, Bucks, husbandman 1
4836860 2307489 2307489 defendant Trippe William husbandman 607908 607908 Trippe, William, of Bledlowe, Bucks, husbandman 0
5086007 2382299 2382299 defendant Bryan Richard   607908 607908 Bryan, Richard, of Bledlowe, Bucks, husbandman, procurator 1
5226329 2423368 2423368 defendant Tryppe John husbandman 607908 607908 Tryppe, John, of Bledlowe, Bucks, husbandman 0
5259638 2433137 2433137 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 0
5276808 2438297 2438297 defendant Payn Thomas clerk 607908 607908 Payn, Thomas, of Bledlowe, Bucks, clerk 3
5315776 2449790 2449790 defendant Curteys William tailor 607908 607908 Curteys, William, of Bledlowe, Bucks, tailor 0
5344249 2458378 2458378 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 0
5348522 2459676 2459676 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 1
5348529 2459677 2459677 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 1
5357304 2462348 2462348 defendant Payn Thomas clerk 607908 607908 Payn, Thomas, of Bledlowe, Bucks, clerk 1
5357307 2462349 2462349 defendant Payn Thomas clerk 607908 607908 Payn, Thomas, of Bledlowe, Bucks, clerk 1
5366334 2465124 2465124 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 1
5366390 2465138 2465138 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 1
5370427 2466336 2466336 defendant Payne Thomas clerk 607908 607908 Payne, Thomas, of Bledlowe, Bucks, clerk 0
5380396 2469443 2469443 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 1
5380453 2469460 2469460 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 1
5380457 2469461 2469461 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 1
5384067 2470530 2470530 defendant Umfrey Thomas husbandman 607908 607908 Umfrey, Thomas, of Bledlowe, Bucks, husbandman 2
5384974 2470776 2470776 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 1
5385014 2470790 2470790 defendant Brian Richard gent 607908 607908 Brian, Richard, of Bledlowe, Bucks, gent 1
5396918 2474201 2474201 plaintiff Brian Richard   607908 607908 Brian, Richard, of Bledlowe, Bucks 0
5397027 2474229 2474229 defendant Bryan Richard   607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent, 0
5397065 2474245 2474245 defendant Brian Richard gent 607908 607908 Brian, Richard, of Bledlowe, Bucks, gent 0
5424036 2482140 2482140 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 0
5424106 2482170 2482170 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 0
5467643 2495249 2495249 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 0
5467645 2495250 2495250 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 0
5467657 2495255 2495255 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 0
5540271 2517085 2517085 defendant Bachell Thomas gent 607908 607908 Bachell, Thomas, of Bledlowe, Bucks, gent 1
5542747 2517852 2517852 defendant Fachell Thomas gent 607908 607908 Fachell, Thomas, of Bledlowe, Bucks, gent 0
5542751 2517853 2517853 defendant Fachell Thomas gent 607908 607908 Fachell, Thomas, of Bledlowe, Bucks, gent 0
5608408 2537532 2537532 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 1
5608427 2537538 2537538 defendant Bryan Richard gent 607908 607908 Bryan, Richard, of Bledlowe, Bucks, gent 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);