names

33 rows where place_id = 616192

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3713156 1930425 1930425 defendant Pryns John yeoman 616192 616192 Pryns, John, of Kypax, yeoman 1
3713157 1930425 1930425 defendant Pryns William yeoman 616192 616192 Pryns, William, of Kypax, yeoman 2
3728600 1935188 1935188 defendant Prynce John yeoman 616192 616192 Prynce, John, of Kypax, yeoman 1
3728601 1935188 1935188 defendant Prynce William yeoman 616192 616192 Prynce, William, of Kypax, yeoman 2
3736923 1937799 1937799 defendant Prynce John yeoman 616192 616192 Prynce, John, of Kypax, yeoman 1
3736924 1937799 1937799 defendant Prynce William husbandman 616192 616192 Prynce, William, of Kypax, husbandman 2
4430422 2174296 2174296 defendant Goldesburgh Adam de   616192 616192 Goldesburgh, Adam de, of Kypax 1
4671458 2256723 2256723 defendant Marchall Richard yeoman 616192 616192 Marchall, Richard, of Kypax, yeoman 0
4671459 2256723 2256723 defendant Huchonson John husbandman 616192 616192 Huchonson, John, of Kypax, husbandman 1
4671460 2256723 2256723 defendant Lowe John husbandman 616192 616192 Lowe, John, of Kypax, husbandman 2
4671461 2256723 2256723 defendant Huchonson Robert --- husbandman 616192 616192 Huchonson, Robert ---, of Kypax, husbandman 3
4671462 2256723 2256723 defendant Hogeson Robert husbandman 616192 616192 Hogeson, Robert, of Kypax, husbandman 4
4671463 2256723 2256723 defendant Thomlynson John husbandman 616192 616192 Thomlynson, John, of Kypax, husbandman 5
4671464 2256723 2256723 defendant Brymston William husbandman 616192 616192 Brymston, William, of Kypax, husbandman 6
4671465 2256723 2256723 defendant Brigge Thomas de husbandman 616192 616192 Brigge, Thomas de, of Kypax, husbandman 7
4671466 2256723 2256723 defendant Smyth Robert husbandman 616192 616192 Smyth, Robert, of Kypax, husbandman 8
4671467 2256723 2256723 defendant Smyth Richard husbandman 616192 616192 Smyth, Richard, of Kypax, husbandman 9
4671468 2256723 2256723 defendant Smyth Simon husbandman 616192 616192 Smyth, Simon, of Kypax, husbandman 10
4671469 2256723 2256723 defendant Tournoure Thomas husbandman 616192 616192 Tournoure, Thomas, of Kypax, husbandman 11
4671470 2256723 2256723 defendant Hunte John husbandman 616192 616192 Hunte, John, of Kypax, husbandman 12
4671471 2256723 2256723 defendant Shalooke Richard husbandman 616192 616192 Shalooke, Richard, of Kypax, husbandman 13
4671472 2256723 2256723 defendant Yarum Henry husbandman 616192 616192 Yarum, Henry, of Kypax, husbandman 14
4671474 2256723 2256723 defendant Milnar Willaim husbandman 616192 616192 Milnar, Willaim, of Kypax, husbandman 16
4671475 2256723 2256723 defendant Williamson Gilson John husbandman 616192 616192 Williamson Gilson, John, of Kypax, husbandman 17
4671476 2256723 2256723 defendant Dogeson Robert husbandman 616192 616192 Dogeson, Robert, of Kypax, husbandman 18
4671477 2256723 2256723 defendant Medley John husbandman 616192 616192 Medley, John, of Kypax, husbandman 19
4671478 2256723 2256723 defendant Hillom Thomas husbandman 616192 616192 Hillom, Thomas, of Kypax, husbandman 20
5001799 2357424 2357424 defendant Pacheth Thomas yeoman 616192 616192 Pacheth, Thomas, of Kypax, yeoman 1
5001800 2357424 2357424 defendant Parkur Richard husbandman 616192 616192 Parkur, Richard, of Kypax, husbandman 2
5001803 2357425 2357425 defendant Pacheth Thomas yeoman 616192 616192 Pacheth, Thomas, of Kypax, yeoman 1
5001804 2357425 2357425 defendant Parkur Richard husbandman 616192 616192 Parkur, Richard, of Kypax, husbandman 2
5136159 2397088 2397088 defendant Lawe William husbandman 616192 616192 Lawe, William, of Kypax, husbandman 0
5136160 2397088 2397088 defendant Balm John   616192 616192 Balm, John, of Kypax, vicar 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);