names

32 rows where place_id = 777338

✎ 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
4643993 2244342 2244342 defendant Spenser Simon   777338 777338 Spenser, Simon, of Leighton Buzzard, Beds 1
4732569 2275362 2275362 defendant Bagenhale William gent 777338 777338 Bagenhale, William, of Leighton Buzzard, Beds, gent 0
4736200 2276457 2276457 defendant Holynden Thomas husbandman 777338 777338 Holynden, Thomas, of Leighton Buzzard, Beds, husbandman 0
4833601 2306517 2306517 defendant Wayn Walter husbandman 777338 777338 Wayn, Walter, of Leighton Buzzard, Beds, husbandman 2
4993326 2354875 2354875 defendant Halsey John chapman 777338 777338 Halsey, John, of Leighton Buzzard, Beds, chapman 1
4993330 2354876 2354876 defendant Halsey John chapman 777338 777338 Halsey, John, of Leighton Buzzard, Beds, chapman 1
4997595 2356135 2356135 defendant Byllyngton Thomas maltman 777338 777338 Byllyngton, Thomas, of Leighton Buzzard, Beds, maltman 0
4997601 2356136 2356136 defendant Byllyngton Thomas maltman 777338 777338 Byllyngton, Thomas, of Leighton Buzzard, Beds, maltman 0
5003244 2357849 2357849 plaintiff Palmer William   777338 777338 Palmer, William, of Leighton Buzzard, Beds 0
5005075 2358384 2358384 defendant Roger John chapman 777338 777338 Roger, John, of Leighton Buzzard, Beds, chapman 1
5005079 2358385 2358385 defendant Roger John chapman 777338 777338 Roger, John, of Leighton Buzzard, Beds, chapman 1
5147612 2400440 2400440 defendant Crane Robert husbandman 777338 777338 Crane, Robert, of Leighton Buzzard, Beds, husbandman 3
5151532 2401596 2401596 defendant Crane John chapman 777338 777338 Crane, John, of Leighton Buzzard, Beds, chapman 1
5151535 2401597 2401597 defendant Crane John chapman 777338 777338 Crane, John, of Leighton Buzzard, Beds, chapman 1
5152643 2401913 2401913 defendant Harnell John husbandman 777338 777338 Harnell, John, of Leighton Buzzard, Beds, husbandman 0
5167240 2406151 2406151 defendant Crane Robert husbandman 777338 777338 Crane, Robert, of Leighton Buzzard, Beds, husbandman 3
5169660 2406862 2406862 defendant Crane John chapman 777338 777338 Crane, John, of Leighton Buzzard, Beds, chapman 1
5169663 2406863 2406863 defendant Crane John chapman 777338 777338 Crane, John, of Leighton Buzzard, Beds, chapman 1
5170334 2407053 2407053 defendant Harnett John husbandman 777338 777338 Harnett, John, of Leighton Buzzard, Beds, husbandman 0
5179498 2409738 2409738 defendant Hardyng William maltman 777338 777338 Hardyng, William, of Leighton Buzzard, Beds, maltman 0
5185019 2411360 2411360 defendant Crane John yeoman 777338 777338 Crane, John, of Leighton Buzzard, Beds, yeoman 0
5185022 2411361 2411361 defendant Crane John yeoman 777338 777338 Crane, John, of Leighton Buzzard, Beds, yeoman 0
5196567 2414747 2414747 defendant Coteler John yeoman 777338 777338 Coteler, John, of Leighton Buzzard, Beds, yeoman 2
5205830 2417440 2417440 defendant Crane Robert   777338 777338 Crane, Robert, of Leighton Buzzard, Beds, chopchirche 3
5209700 2418576 2418576 defendant Coteler John yeoman 777338 777338 Coteler, John, of Leighton Buzzard, Beds, yeoman 2
5276328 2438148 2438148 defendant Archer alias Wilmot John maltman 777338 777338 Archer alias Wilmot, John, of Leighton Buzzard, Beds, maltman 2
5391213 2472566 2472566 defendant Halsy John mercer 777338 777338 Halsy, John, of Leighton Buzzard, Beds, mercer 0
5419958 2480885 2480885 defendant Raymer William chapman 777338 777338 Raymer, William, of Leighton Buzzard, Beds, chapman 1
5428419 2483427 2483427 defendant Hardyng William husbandman 777338 777338 Hardyng, William, of Leighton Buzzard, Beds, husbandman 0
5434596 2485283 2485283 defendant Halsy John mercer 777338 777338 Halsy, John, of Leighton Buzzard, Beds, mercer 5
5452718 2490695 2490695 defendant Draper William husbandman 777338 777338 Draper, William, of Leighton Buzzard, Beds, husbandman 0
5473677 2497094 2497094 defendant Halsey John chapman 777338 777338 Halsey, John, of Leighton Buzzard, Beds, chapman 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);