names

30 rows where place_id = 586284

✎ 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
3588353 1864007 1864007 defendant Chelys Walter husbandman 586284 586284 Chelys, Walter, of Orby, husbandman 1
3588356 1864008 1864008 defendant Chelys Walter husbandman 586284 586284 Chelys, Walter, of Orby, husbandman 1
3609367 1870589 1870589 defendant Wodeford John yeoman 586284 586284 Wodeford, John, of Orby, yeoman 0
3661965 1914033 1914033 defendant Browne Henry yeoman 586284 586284 Browne, Henry, of Orby, yeoman 0
3753151 1942924 1942924 defendant Fobe John husbandman 586284 586284 Fobe, John, of Orby, husbandman 1
3771696 1948848 1948848 defendant Elyot John   586284 586284 Elyot, John, of Orby, mason 0
3821925 1964750 1964750 defendant Broune Henry husbandman 586284 586284 Broune, Henry, of Orby, husbandman 0
3837302 1969575 1969575 defendant Balard Richard yeoman 586284 586284 Balard, Richard, of Orby, yeoman 0
3843651 1971547 1971547 defendant Fobbe John yeoman 586284 586284 Fobbe, John, of Orby, yeoman 1
3843905 1971632 1971632 defendant Fobbe John yeoman 586284 586284 Fobbe, John, of Orby, yeoman 1
3852887 1974517 1974517 defendant Lokkyng Walter husbandman 586284 586284 Lokkyng, Walter, of Orby, husbandman 0
4022991 2032942 2032942 defendant Richardson John   586284 586284 Richardson, John, of Orby, wheelwright 3
4037491 2038070 2038070 defendant Lytlor or Litellore Randolph gent 586284 586284 Lytlor or Litellore, Randolph, of Orby, gent 0
4091184 2057137 2057137 defendant Stephenson William yeoman 586284 586284 Stephenson, William, of Orby, yeoman 1
4148594 2077634 2077634 defendant Chambers John yeoman 586284 586284 Chambers, John, of Orby, yeoman 1
4277131 2121935 2121935 defendant Lille Robert yeoman 586284 586284 Lille, Robert, of Orby, yeoman 0
4560525 2219230 2219230 defendant Almotson William   586284 586284 Almotson, William, of Orby 0
4766635 2285556 2285556 defendant Pepy John husbandman 586284 586284 Pepy, John, of Orby, husbandman 3
4826400 2304294 2304294 defendant Poupe or Ponpe John husbandman 586284 586284 Poupe or Ponpe, John, of Orby, husbandman 2
4829685 2305331 2305331 defendant Yate John husbandman 586284 586284 Yate, John, of Orby, husbandman 0
4845554 2310118 2310118 defendant Zytte John husbandman 586284 586284 Zytte, John, of Orby, husbandman 0
4899003 2326331 2326331 defendant Plant John husbandman 586284 586284 Plant, John, of Orby, husbandman 7
4979457 2350811 2350811 defendant Heryng Robert clerk 586284 586284 Heryng, Robert, of Orby, clerk 2
5112431 2390023 2390023 defendant Coke Richard husbandman 586284 586284 Coke, Richard, of Orby, husbandman 0
5189372 2412624 2412624 defendant Kirkeby Walter   586284 586284 Kirkeby, Walter, of Orby, vicar & clerk 0
5246725 2429205 2429205 defendant Claterton Robert yeoman 586284 586284 Claterton, Robert, of Orby, yeoman 0
5294320 2443313 2443313 defendant Doughty Richard husbandman 586284 586284 Doughty, Richard, of Orby, husbandman 0
5315602 2449732 2449732 plaintiff Coppy Robert   586284 586284 Coppy, Robert, of Orby 0
5336514 2455992 2455992 defendant Doughty Richard husbandman 586284 586284 Doughty, Richard, of Orby, husbandman 0
5410163 2477991 2477991 defendant Heryng Robert   586284 586284 Heryng, Robert, of Orby, husbandman, son of Walter Heryng 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);