names

30 rows where place_id = 592717

✎ 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
3608624 1870359 1870359 defendant Broke Robert laborer 592717 592717 Broke, Robert, of Hadley, Middx, laborer 0
3663487 1914505 1914505 defendant Halle Elias   592717 592717 Halle, Elias, of Hadley, Middx, malt man 1
3673255 1917649 1917649 defendant Nele John maltman 592717 592717 Nele, John, of Hadley, Middx, maltman 1
3679691 1919715 1919715 defendant Nele John maltman 592717 592717 Nele, John, of hadley, Middx, maltman 0
3733535 1936734 1936734 defendant Nele John maltman 592717 592717 Nele, John, of Hadley, Middx, maltman 0
3783340 1952541 1952541 defendant Jakson Thomas maltman 592717 592717 Jakson, Thomas, of Hadley, Middx, maltman 1
3783401 1952558 1952558 defendant Jakson Thomas maltman 592717 592717 Jakson, Thomas, of Hadley, Middx, maltman 1
3826883 1966258 1966258 defendant Hall John maltman 592717 592717 Hall, John, of Hadley, Middx, maltman 1
3837296 1969572 1969572 defendant Bassett John yeoman 592717 592717 Bassett, John, of Hadley, Middx, yeoman 0
3837300 1969574 1969574 defendant Bassett John yeoman 592717 592717 Bassett, John, of Hadley, Middx, yeoman 0
3868350 1979654 1979654 defendant Wulffe alias Wylleys William husbandman 592717 592717 Wulffe alias Wylleys, William, of Hadley, Middx, husbandman 3
3944628 2005219 2005219 plaintiff Bayllye John husbandman 592717 592717 Bayllye, John, of Hadley, Middx, husbandman 0
3951420 2007559 2007559 defendant Carewe Roger esq 592717 592717 Carewe, Roger, of Hadley, Middx, esq 0
4176301 2087190 2087190 defendant Ashcrofte Reginald yeoman 592717 592717 Ashcrofte, Reginald, of Hadley, Middx, yeoman 0
4176309 2087193 2087193 defendant Ashcrofte Reginald yeoman 592717 592717 Ashcrofte, Reginald, of Hadley, Middx, yeoman 0
4197746 2094768 2094768 defendant Foxe Paul gent 592717 592717 Foxe, Paul, of Hadley, Middx, gent 2
4220378 2102632 2102632 defendant Parnell George yeoman 592717 592717 Parnell, George, of Hadley, Middx, yeoman 1
5086411 2382422 2382422 defendant Garard John smith 592717 592717 Garard, John, of Hadley, Middx, smith 2
5097345 2385653 2385653 defendant Porter William yeoman 592717 592717 Porter, William, of Hadley, Middx, yeoman 0
5099227 2386201 2386201 defendant Grene William husbandman 592717 592717 Grene, William, of Hadley, Middx, husbandman 1
5194412 2414094 2414094 defendant Parkyn Richard husbandman 592717 592717 Parkyn, Richard, of Hadley, Middx, husbandman 3
5208742 2418280 2418280 defendant Parkyn Richard husbandman 592717 592717 Parkyn, Richard, of Hadley, Middx, husbandman 3
5264021 2434507 2434507 defendant Grene John maltman 592717 592717 Grene, John, of Hadley, Middx, maltman 0
5289329 2441880 2441880 defendant Grene John husbandman 592717 592717 Grene, John, of Hadley, Middx, husbandman 0
5316434 2449996 2449996 defendant Belamy Robert yeoman 592717 592717 Belamy, Robert, of Hadley, Middx, yeoman 2
5336857 2456089 2456089 defendant Reynold John laborer 592717 592717 Reynold, John, of Hadley, Middx, laborer 2
5344991 2458594 2458594 defendant Belamy Robert yeoman 592717 592717 Belamy, Robert, of Hadley, Middx, yeoman 2
5371239 2466588 2466588 defendant Pygote Robert laborer 592717 592717 Pygote, Robert, of Hadley, Middx, laborer 2
5419936 2480880 2480880 defendant Welle Henry maltman 592717 592717 Welle, Henry, of Hadley, Middx, maltman 2
5553877 2521173 2521173 defendant Bunny John maltman 592717 592717 Bunny, John, of Hadley, Middx, maltman 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);