names

36 rows where place_id = 600302

✎ 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
3640520 1907470 1907470 defendant Cooper John husbandman 600302 600302 Cooper, John, of Hamelden, husbandman 0
3915867 1995685 1995685 defendant Dowglas Ralph smith 600302 600302 Dowglas, Ralph, of Hamelden, smith 0
3966537 2012928 2012928 defendant Shipwashe Thomas (legal representative) 600302 600302 Shipwashe, Thomas, of Hamelden, yeoman, executrix of 0
4060830 2046280 2046280 defendant Bolland John   600302 600302 Bolland, John, of Hamelden, Rutland husbandman 0
4060832 2046280 2046280 defendant Grey John husbandman 600302 600302 Grey, John, of Hamelden, husbandman 2
4589615 2228121 2228121 plaintiff Lokysore John   600302 600302 Lokysore, John, of Hamelden 0
4589617 2228121 2228121 defendant Foster Richard   600302 600302 Foster, Richard, of Hamelden 0
4748563 2280081 2280081 defendant London William husbandman 600302 600302 London, William, of Hamelden, husbandman 0
4856450 2313396 2313396 defendant Scrop Thomas esq 600302 600302 Scrop, Thomas, of Hamelden, esq 0
4876426 2319587 2319587 plaintiff Lokesere John husbandman 600302 600302 Lokesere, John, of Hamelden, husbandman 1
4876427 2319587 2319587 defendant Godarde John gent 600302 600302 Godarde, John, of Hamelden, gent 0
4910664 2329845 2329845 plaintiff Bornell John   600302 600302 Bornell, John, of Hamelden 0
4910665 2329845 2329845 defendant Gybbys John husbandman 600302 600302 Gybbys, John, of Hamelden, husbandman 0
4978223 2350437 2350437 plaintiff Reynald William   600302 600302 Reynald, William, of Hamelden, son of Reynald, John, junior 0
5140401 2398294 2398294 defendant West Robert yeoman 600302 600302 West, Robert, of Hamelden, yeoman 2
5140403 2398294 2398294 defendant Flowre Thomas yeoman 600302 600302 Flowre, Thomas, of Hamelden, yeoman 4
5161538 2404473 2404473 defendant West Robert yeoman 600302 600302 West, Robert, of Hamelden, yeoman 2
5161540 2404473 2404473 defendant Floure Thomas yeoman 600302 600302 Floure, Thomas, of Hamelden, yeoman 4
5175914 2408637 2408637 defendant West Robert yeoman 600302 600302 West, Robert, of Hamelden, yeoman 2
5175916 2408637 2408637 defendant Floure Thomas yeoman 600302 600302 Floure, Thomas, of Hamelden, yeoman 4
5194753 2414207 2414207 defendant Davy Reginald husbandman 600302 600302 Davy, Reginald, of Hamelden, husbandman 0
5197607 2415037 2415037 defendant West Robert yeoman 600302 600302 West, Robert, of Hamelden, yeoman 2
5197609 2415037 2415037 defendant Floure Thomas   600302 600302 Floure, Thomas, of Hamelden 4
5208922 2418336 2418336 defendant Davy Reginald husbandman 600302 600302 Davy, Reginald, of Hamelden, husbandman 0
5278282 2438748 2438748 defendant Plowe Robert husbandman 600302 600302 Plowe, Robert, of Hamelden, husbandman 0
5308317 2447521 2447521 defendant Plowe Robert husbandman 600302 600302 Plowe, Robert, of Hamelden, husbandman 0
5310519 2448182 2448182 defendant Bisshop Nicholas yeoman 600302 600302 Bisshop, Nicholas, of Hamelden, yeoman 0
5319371 2450885 2450885 defendant Shalden Thomas yeoman 600302 600302 Shalden, Thomas, of Hamelden, yeoman 4
5399265 2474861 2474861 defendant Shalden Thomas yeoman 600302 600302 Shalden, Thomas, of Hamelden, yeoman 0
5493492 2502966 2502966 defendant London John husbandman 600302 600302 London, John, of Hamelden, husbandman 1
5563573 2523953 2523953 defendant Herne or Herve John carpetner 600302 600302 Herne or Herve, John, of Hamelden, carpetner 0
5563576 2523954 2523954 defendant Herne or Herve John carpenter 600302 600302 Herne or Herve, John, of Hamelden, carpenter 0
5621218 2550521 2550521 defendant Douncel Richard   600302 600302 Douncel, Richard, of Hamelden 0
5625153 2551805 2551805 defendant Tanner Edmund husbandman 600302 600302 Tanner, Edmund, of Hamelden, husbandman 0
5630943 2553687 2553687 defendant Morys Walter husbandman 600302 600302 Morys, Walter, of Hamelden, husbandman 1
5630946 2553688 2553688 defendant Morys Walter husbandman 600302 600302 Morys, Walter, of Hamelden, husbandman 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);