names

23 rows where place_id = 587313

✎ 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
3591048 1864828 1864828 defendant Hakke Robert yeoman 587313 587313 Hakke, Robert, of Heylesdon, yeoman 0
3608132 1870195 1870195 defendant Pory William clerk 587313 587313 Pory, William, of Heylesdon, clerk 0
3611937 1871395 1871395 defendant Wastell John husbandman 587313 587313 Wastell, John, of Heylesdon, husbandman 0
3617394 1873059 1873059 plaintiff Forest John chaplain 587313 587313 Forest, John, of Heylesdon, chaplain 0
3623839 1874985 1874985 defendant Pory William clerk 587313 587313 Pory, William, of Heylesdon, clerk 2
3633176 1905189 1905189 defendant Wacell John, junior husbandman 587313 587313 Wacell, John, junior, of Heylesdon, husbandman 0
3674857 1918163 1918163 defendant Tonell or Tovell John miller 587313 587313 Tonell or Tovell, John, of Heylesdon, miller 0
3762794 1946000 1946000 defendant Tonell John husbandman 587313 587313 Tonell, John, of Heylesdon, husbandman 3
3884527 1985098 1985098 defendant Danson John yeoman 587313 587313 Danson, John, of Heylesdon, yeoman 0
3896239 1988950 1988950 defendant Olyver John pedder 587313 587313 Olyver, John, of Heylesdon, pedder 3
4521719 2207126 2207126 defendant Broun John miller 587313 587313 Broun, John, of Heylesdon, miller 0
4577408 2224451 2224451 plaintiff Otere John   587313 587313 Otere, John, of Heylesdon, parson 1
4612152 2234866 2234866 plaintiff Millere Robert   587313 587313 Millere, Robert, of Heylesdon 2
4637247 2242444 2242444 defendant Hoo Walter de   587313 587313 Hoo, Walter de, of Heylesdon, bailiff 5
4831210 2305793 2305793 defendant Millere Simon miller 587313 587313 Millere, Simon, of Heylesdon, miller 0
4937854 2338220 2338220 defendant Broke Roger fuller 587313 587313 Broke, Roger, of Heylesdon, fuller 1
4950540 2342128 2342128 defendant Sellyng Richard esq 587313 587313 Sellyng, Richard, of Heylesdon, esq 1
5032828 2366488 2366488 defendant Martyn Henry laborer 587313 587313 Martyn, Henry, of Heylesdon, laborer 4
5214319 2419920 2419920 defendant Gebon Richard husbandman 587313 587313 Gebon, Richard, of Heylesdon, husbandman 4
5354247 2461393 2461393 defendant Akke Robert husbandman 587313 587313 Akke, Robert, of Heylesdon, husbandman 3
5548504 2519600 2519600 defendant Tonell William miller 587313 587313 Tonell, William, of Heylesdon, miller 1
5553479 2521052 2521052 defendant Byshop John husbandman 587313 587313 Byshop, John, of Heylesdon, husbandman 0
5586817 2530916 2530916 defendant Greneloff Robert chaplain 587313 587313 Greneloff, Robert, of Heylesdon, chaplain 4

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