names

28 rows where place_id = 594921

✎ 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
3618146 1873300 1873300 defendant Bertlot Thomas yeoman 594921 594921 Bertlot, Thomas, of Heston, Middx, yeoman 0
3727306 1934815 1934815 defendant Porter John tailor 594921 594921 Porter, John, of Heston, Middx, tailor 3
3727311 1934817 1934817 defendant Porter John tailor 594921 594921 Porter, John, of Heston, Middx, tailor 0
3756593 1944043 1944043 defendant Barttelot John yeoman 594921 594921 Barttelot, John, of Heston, Middx, yeoman 1
3858801 1976430 1976430 defendant Awnsham Richard   594921 594921 Awnsham, Richard, of Heston, Middx, gent, fellow of Inner Temple 1
3874673 1981747 1981747 defendant Cole Walter yeoman 594921 594921 Cole, Walter, of Heston, Middx, yeoman 0
3876266 1982302 1982302 defendant Clyfton Robert husbandman 594921 594921 Clyfton, Robert, of Heston, Middx, husbandman 3
3963414 2011808 2011808 plaintiff Wynkyn Richard (legal representative) 594921 594921 Wynkyn, Richard, of Heston, Middx, mercer, executors of 0
4086232 2055350 2055350 defendant Horseley John yeoman 594921 594921 Horseley, John, of Heston, Middx, yeoman 1
4217106 2101476 2101476 defendant Shawe Francis yeoman 594921 594921 Shawe, Francis, of heston, Middx, yeoman 0
4235493 2107982 2107982 defendant Rodes John yeoman 594921 594921 Rodes, John, of Heston, Middx, yeoman 0
4289265 2126218 2126218 defendant Redheade Robert gent 594921 594921 Redheade, Robert, of Heston, Middx, or of London, gent 0
4600978 2231533 2231533 defendant Cumbery John   594921 594921 Cumbery, John, of Heston, Middx 1
4664914 2250506 2250506 defendant Palette William husbandman 594921 594921 Palette, William, of Heston, Middx, husbandman 0
4726352 2273526 2273526 defendant Godelerke John husbandman 594921 594921 Godelerke, John, of Heston, Middx, husbandman 0
4726355 2273527 2273527 defendant Godelerke John husbandman 594921 594921 Godelerke, John, of Heston, Middx, husbandman 0
4803769 2297362 2297362 defendant Olyver Robert gent 594921 594921 Olyver, Robert, of Heston, Middx, gent 0
4803771 2297363 2297363 defendant Olyver Robert gent 594921 594921 Olyver, Robert, of Heston, Middx, gent 0
4810308 2299368 2299368 defendant Palet John husbandman 594921 594921 Palet, John, of Heston, Middx, husbandman 3
4810434 2299408 2299408 defendant Palet John husbandman 594921 594921 Palet, John, of Heston, Middx, husbandman 3
4940043 2338913 2338913 defendant Belwys Henry yeoman 594921 594921 Belwys, Henry, of Heston, Middx, yeoman 0
5014835 2361214 2361214 defendant Akastere or Akastell John husbandman 594921 594921 (Akastere or Akastell, John, of Heston, Middx, husbandman 4
5224213 2422752 2422752 defendant Soubury or Sonbury Richard husbandman 594921 594921 Soubury or Sonbury, Richard, of Heston, Middx, husbandman 0
5323181 2452013 2452013 defendant Ravener William husbandman 594921 594921 Ravener, William, of Heston, Middx, husbandman 1
5374591 2467659 2467659 defendant Swyfte Richard smith 594921 594921 Swyfte, Richard, of Heston, Middx, smith 0
5374592 2467659 2467659 defendant Abry John husbandman 594921 594921 Abry, John, of Heston, Middx, husbandman 1
5525231 2512485 2512485 defendant Bratlot Emma widow 594921 594921 Bratlot, Emma, of Heston, Middx, widow 0
5565737 2524570 2524570 defendant Chyld Richard butcher 594921 594921 Chyld, Richard, of Heston, Middx, butcher 1

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);