names

33 rows where place_id = 768206

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4546964 2214984 2214984 defendant Hopkynson Gyllesson John   768206 768206 Hopkynson Gyllesson, John, of Brymyngton 0
4653475 2247019 2247019 defendant Oven William husbandman 768206 768206 Oven, William, of Brymyngton, husbandman 0
4653482 2247021 2247021 defendant Batte John, senior husbandman 768206 768206 Batte, John, senior, of Brymyngton, husbandman 1
4653483 2247021 2247021 defendant Batte John, junior husbandman 768206 768206 Batte, John, junior, of Brymyngton, husbandman 2
4867894 2316928 2316928 defendant Bryghtrychefeld Henry yeoman 768206 768206 Bryghtrychefeld, Henry, of Brymyngton, yeoman 1
4867895 2316928 2316928 defendant Bate John husbandman 768206 768206 Bate, John, of Brymyngton, husbandman 2
4948239 2341424 2341424 defendant Hynkirshill Robert husbandman 768206 768206 Hynkirshill, Robert, of Brymyngton, husbandman 2
5236590 2426288 2426288 defendant Darton Thomas husbandman 768206 768206 Darton, Thomas, of Brymyngton, husbandman 4
5236591 2426288 2426288 defendant Wilkynson Richard husbandman 768206 768206 Wilkynson, Richard, of Brymyngton, husbandman 5
5323967 2452254 2452254 defendant Whyte Robert husbandman 768206 768206 Whyte, Robert, of Brymyngton, husbandman 1
5333952 2455230 2455230 defendant Maryot William husbandman 768206 768206 Maryot, William, of Brymyngton, husbandman 0
5333954 2455231 2455231 defendant Maryot William husbandman 768206 768206 Maryot, William, of Brymyngton, husbandman 0
5333955 2455231 2455231 defendant Higdon Nicholas husbandman 768206 768206 Higdon, Nicholas, of Brymyngton, husbandman 1
5333956 2455231 2455231 defendant Stubbyng William weaver 768206 768206 Stubbyng, William, of Brymyngton, weaver 2
5333957 2455231 2455231 defendant Clerke Edmund husbandman 768206 768206 Clerke, Edmund, of Brymyngton, husbandman 3
5333958 2455231 2455231 defendant Wylkynson Thomas husbandman 768206 768206 Wylkynson, Thomas, of Brymyngton, husbandman 4
5333959 2455231 2455231 defendant Darton George husbandman 768206 768206 Darton, George, of Brymyngton, husbandman 5
5333960 2455231 2455231 defendant Wylkynson John husbandman 768206 768206 Wylkynson, John, of Brymyngton, husbandman 6
5333961 2455231 2455231 defendant Jonson John husbandman 768206 768206 Jonson, John, of Brymyngton, husbandman 7
5333962 2455231 2455231 defendant Clyf Reginald tailor 768206 768206 Clyf, Reginald, of Brymyngton, tailor 8
5333963 2455231 2455231 defendant Marler John   768206 768206 Marler, John, of Brymyngton, scythe smith 9
5333964 2455231 2455231 defendant Dent John husbandman 768206 768206 Dent, John, of Brymyngton, husbandman 10
5369356 2466017 2466017 defendant Mayote William husbandman 768206 768206 Mayote, William, of Brymyngton, husbandman 3
5369367 2466018 2466018 defendant Maryate William husbandman 768206 768206 Maryate, William, of Brymyngton, husbandman 3
5428313 2483393 2483393 defendant Jonson Celia widow 768206 768206 Jonson, Celia, of Brymyngton, widow 5
5435867 2485672 2485672 defendant Matyotte William husbandman 768206 768206 Matyotte, William, of Brymyngton, husbandman 0
5435868 2485672 2485672 defendant Hugdon John husbandman 768206 768206 Hugdon, John, of Brymyngton, husbandman 1
5445700 2488601 2488601 defendant Jonson Cecily widow 768206 768206 Jonson, Cecily, of Brymyngton, widow 5
5447642 2489167 2489167 defendant Johnson Celia widow 768206 768206 Johnson, Celia, of Brymyngton, widow 0
5458453 2492420 2492420 defendant Jonson Cecilia widow 768206 768206 Jonson, Cecilia, of Brymyngton, widow 5
5458458 2492421 2492421 defendant Johnson Celia widow 768206 768206 Johnson, Celia, of Brymyngton, widow 3
5523239 2512097 2512097 defendant Tubyng Clemence widow 768206 768206 Tubyng, Clemence, of Brymyngton, widow 1
5622840 2551073 2551073 defendant Grubber Nicholas   768206 768206 Grubber, Nicholas, of Brymyngton 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);