names

28 rows where place_id = 772450

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4588918 2227907 2227907 defendant Blak Peter   772450 772450 Blak, Peter, of Leveryngton, Cambs 1
4675332 2257896 2257896 defendant Stokyl Robert husbandman 772450 772450 Stokyl, Robert, of Leveryngton, Cambs, husbandman 2
4680322 2259458 2259458 defendant Everard Margery widow 772450 772450 Everard, Margery, of Leveryngton, Cambs, widow 0
4681363 2259793 2259793 defendant Marchals Adam gent 772450 772450 Marchals, Adam, of Leveryngton, Cambs, gent 4
4705993 2267249 2267249 defendant Everard Margaret widow 772450 772450 Everard, Margaret, of Leveryngton, Cambs, widow 0
4726172 2273470 2273470 defendant Markhant Henry husbandman 772450 772450 Markhant, Henry, of Leveryngton, Cambs, husbandman 0
4726175 2273470 2273470 defendant Reynald Thomas husbandman 772450 772450 Reynald, Thomas, of Leveryngton, Cambs, husbandman 3
4729650 2274485 2274485 defendant Everard Margaret widow 772450 772450 Everard, Margaret, of Leveryngton, Cambs, widow 0
4914144 2330935 2330935 defendant Edward Martin husbandman 772450 772450 Edward, Martin, of Leveryngton, Cambs, husbandman 0
4915381 2331318 2331318 defendant Dyggeby Reginald husbandman 772450 772450 Dyggeby, Reginald, of Leveryngton, Cambs, husbandman 1
4916359 2331618 2331618 defendant Brene Robert yeoman 772450 772450 Brene, Robert, of Leveryngton, Cambs, yeoman 0
4918773 2332384 2332384 defendant Grene Robert husbandman 772450 772450 Grene, Robert, of Leveryngton, Cambs, husbandman 0
4923088 2333640 2333640 defendant Everard William gent 772450 772450 Everard, William, of Leveryngton, Cambs, gent 0
4994115 2355114 2355114 defendant Haddylyseye Robert yeoman 772450 772450 Haddylyseye, Robert, of Leveryngton, Cambs, yeoman 0
5005215 2358422 2358422 defendant Edward Martin husbandman 772450 772450 Edward, Martin, of Leveryngton, Cambs, husbandman 0
5008797 2359464 2359464 defendant Coston Richard husbandman 772450 772450 Coston, Richard, of Leveryngton, Cambs, husbandman 0
5008801 2359465 2359465 defendant Dygby Thomas husbandman 772450 772450 Dygby, Thomas, of Leveryngton, Cambs, husbandman 0
5043071 2369543 2369543 defendant Costyn Nicholas yeoman 772450 772450 Costyn, Nicholas, of Leveryngton, Cambs, yeoman 0
5149562 2401001 2401001 defendant Everard William gent 772450 772450 Everard, William, of Leveryngton, Cambs, gent 0
5161952 2404608 2404608 defendant Pey John   772450 772450 Pey, John, of Leveryngton, Cambs, swan herd 0
5176190 2408728 2408728 defendant Pey John   772450 772450 Pey, John, of Leveryngton, Cambs, swan herd 0
5198139 2415203 2415203 defendant Poy John   772450 772450 Poy, John, of Leveryngton, Cambs, swan herd 0
5438675 2486501 2486501 defendant Raynold John husbandman 772450 772450 Raynold, John, of Leveryngton, Cambs, husbandman 2
5448362 2489404 2489404 defendant Page Thomas husbandman 772450 772450 Page, Thomas, of Leveryngton, Cambs, husbandman 0
5460888 2493203 2493203 defendant Page Thomas husbandman 772450 772450 Page, Thomas, of Leveryngton, Cambs, husbandman 0
5464523 2494309 2494309 defendant Raynold John husbandman 772450 772450 Raynold, John, of Leveryngton, Cambs, husbandman 2
5464527 2494310 2494310 defendant Raynold John husbandman 772450 772450 Raynold, John, of Leveryngton, Cambs, husbandman 2
5472470 2496731 2496731 defendant Page Thomas husbandman 772450 772450 Page, Thomas, of Leveryngton, Cambs, husbandman 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);