names

30 rows where place_id = 650945

✎ 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
3914849 1995314 1995314 plaintiff Clercke William   650945 650945 Clercke, William, of Chesthunte 1
3955582 2009022 2009022 defendant Lowth Oliver yeoman 650945 650945 Lowth, Oliver, of Chesthunte, or of Asheridge, Herts, yeoman 0
4444937 2183389 2183389 defendant Crouche John   650945 650945 Crouche, John, of Chesthunte 1
4508751 2203213 2203213 plaintiff Antony Walter   650945 650945 Antony, Walter, of Chesthunte 0
4512362 2204308 2204308 defendant Crouche John   650945 650945 Crouche, John, of Chesthunte 0
4515873 2205385 2205385 defendant Jordan John   650945 650945 Jordan, John, of Chesthunte 0
4519730 2206527 2206527 defendant Belle John   650945 650945 Belle, John, of Chesthunte, servant of Nicholas 3
4536600 2211726 2211726 plaintiff Godsonde John   650945 650945 Godsonde, John, of Chesthunte 1
4556291 2217908 2217908 defendant Mascall Thomas   650945 650945 Mascall, Thomas, of Chesthunte 4
4618334 2236743 2236743 defendant Crouch Richard   650945 650945 Crouch, Richard, of Chesthunte 0
4618335 2236743 2236743 defendant Martyn William   650945 650945 Martyn, William, of Chesthunte 1
4618336 2236743 2236743 defendant Smyth William   650945 650945 Smyth, William, of Chesthunte 2
4624907 2238762 2238762 defendant Norman Richard   650945 650945 Norman, Richard, of Chesthunte 0
4635513 2241966 2241966 defendant Boteler Geoffrey esq 650945 650945 Boteler, Geoffrey, of Chesthunte, esq 0
4646084 2244929 2244929 plaintiff Perers Richard   650945 650945 Perers, Richard, of Chesthunte 0
4646086 2244929 2244929 defendant Belle Nicholas   650945 650945 Belle, Nicholas, of Chesthunte 1
4686185 2261275 2261275 defendant Turnour Thomas turner 650945 650945 Turnour, Thomas, of Chesthunte, turner 0
4734655 2275995 2275995 defendant Belle Nicholas smith 650945 650945 Belle, Nicholas, of Chesthunte, smith 2
4812953 2300165 2300165 plaintiff Hatteclyff William   650945 650945 Hatteclyff, William, of Chesthunte, vicar 0
4860899 2314767 2314767 defendant Chedewale John tiler 650945 650945 Chedewale, John, of Chesthunte, tiler 0
4860902 2314767 2314767 defendant Mordon John barber 650945 650945 Mordon, John, of Chesthunte, barber 3
5010413 2359915 2359915 plaintiff Blythe Thomas   650945 650945 Blythe, Thomas, of Chesthunte 1
5011139 2360110 2360110 defendant Wygon Thomas husbandman 650945 650945 Wygon, Thomas, of Chesthunte, husbandman 0
5119975 2392279 2392279 defendant Coldham Joan widow 650945 650945 (Coldham, Joan, of Chesthunte, widow 1
5256807 2432253 2432253 defendant Westman Richard husbandman 650945 650945 Westman, Richard, of Chesthunte, husbandman 0
5382914 2470180 2470180 defendant Yonge Thomas shoemaker 650945 650945 Yonge, Thomas, of Chesthunte, shoemaker 0
5382916 2470180 2470180 defendant Hans or Haus John shoemaker 650945 650945 Hans or Haus, John, of Chesthunte, shoemaker 2
5477240 2498202 2498202 defendant Pyke John yeoman 650945 650945 Pyke, John, of Chesthunte, yeoman 1
5628253 2552796 2552796 plaintiff Perers Richard   650945 650945 Perers, Richard, of Chesthunte 0
5628255 2552797 2552797 plaintiff Perers Richard   650945 650945 Perers, Richard, of Chesthunte 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);