names

39 rows where place_id = 609035

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3676670 1918742 1918742 defendant Langley Katherine widow 609035 609035 Langley, Katherine, of Portbury, widow 0
3869138 1979925 1979925 defendant Goodwyn Robert gent 609035 609035 Goodwyn, Robert, of Portbury, gent 0
3910860 1993955 1993955 defendant Hathefyld John, junior husbandman 609035 609035 Hathefyld, John, junior, of Portbury, husbandman 1
3910861 1993955 1993955 defendant Laurence John husbandman 609035 609035 Laurence, John, of Portbury, husbandman 2
3933148 2001379 2001379 defendant Porter Roger husbandman 609035 609035 Porter, Roger, of Portbury, husbandman 0
4961021 2345256 2345256 defendant Smyth Richard smith 609035 609035 Smyth, Richard, of Portbury, smith 0
4961022 2345256 2345256 defendant Toby or Tovy William   609035 609035 Toby or Tovy, William, of Portbury, millward 1
5056295 2373455 2373455 defendant Chapnore John yeoman 609035 609035 Chapnore, John, of Portbury, yeoman 1
5056296 2373455 2373455 defendant Emondes John   609035 609035 Emondes, John, of Portbury, yeoman, servant of Berkley, William, 2
5056300 2373456 2373456 defendant Chapnore John yeoman 609035 609035 Chapnore, John, of Portbury, yeoman 1
5056301 2373456 2373456 defendant Emondes John   609035 609035 Emondes, John, of Portbury, yeoman, servant or Berkley, William 2
5278926 2438948 2438948 defendant Apadam Richard yeoman 609035 609035 Apadam, Richard, of Portbury, yeoman 0
5297757 2444348 2444348 defendant Hill John, sen husbandman 609035 609035 Hill, John, sen, of Portbury, husbandman 4
5313374 2449040 2449040 defendant Hullokke John collier 609035 609035 Hullokke, John, of Portbury, collier 1
5313375 2449040 2449040 defendant Saunder John butcher 609035 609035 Saunder, John, of Portbury, butcher 2
5313376 2449040 2449040 defendant ap Jankyn John husbandman 609035 609035 ap Jankyn, John, of Portbury, husbandman 3
5313377 2449040 2449040 defendant Stanbrigge John husbandman 609035 609035 Stanbrigge, John, of Portbury, husbandman 4
5313378 2449040 2449040 defendant Rogers Richard butcher 609035 609035 Rogers, Richard, of Portbury, butcher 5
5313379 2449040 2449040 defendant Bisshop William husbandman 609035 609035 Bisshop, William, of Portbury, husbandman 6
5313380 2449040 2449040 defendant Blakehed James clerk 609035 609035 Blakehed, James, of Portbury, clerk 7
5313382 2449041 2449041 defendant Tege John husbandman 609035 609035 Tege, John, of Portbury, husbandman 0
5313383 2449041 2449041 defendant Dyker John chapman 609035 609035 Dyker, John, of Portbury, chapman 1
5313384 2449041 2449041 defendant Stanbrigge Robert husbandman 609035 609035 Stanbrigge, Robert, of Portbury, husbandman 2
5313385 2449041 2449041 defendant Stevenys John husbandman 609035 609035 Stevenys, John, of Portbury, husbandman 3
5313386 2449041 2449041 defendant Kyng Thomas husbandman 609035 609035 Kyng, Thomas, of Portbury, husbandman 4
5313387 2449041 2449041 defendant Baker Robert husbandman 609035 609035 Baker, Robert, of Portbury, husbandman 5
5313388 2449041 2449041 defendant Passer John, junior husbandman 609035 609035 Passer, John, junior, of Portbury, husbandman 6
5313389 2449041 2449041 defendant Passer John, senior husbandman 609035 609035 Passer, John, senior, of Portbury, husbandman 7
5313390 2449041 2449041 defendant Savage Thomas husbandman 609035 609035 Savage, Thomas, of Portbury, husbandman 8
5313391 2449041 2449041 defendant Savage John husbandman 609035 609035 Savage, John, of Portbury, husbandman 9
5313392 2449041 2449041 defendant Saymour William, senior husbandman 609035 609035 Saymour, William, senior, of Portbury, husbandman 10
5313393 2449041 2449041 defendant Hill John husbandman 609035 609035 Hill, John, of Portbury, husbandman 11
5313394 2449041 2449041 defendant Moule Thomas husbandman 609035 609035 Moule, Thomas, of Portbury, husbandman 12
5313395 2449041 2449041 defendant Jacob Roger   609035 609035 Jacob, Roger, of Portbury, millward 13
5313396 2449041 2449041 defendant Baker John yeoman 609035 609035 Baker, John, of Portbury, yeoman 14
5347475 2459375 2459375 defendant Wylmot John yeoman 609035 609035 Wylmot, John, of Portbury, yeoman 0
5466580 2494943 2494943 defendant Haket John   609035 609035 Haket, John, of Portbury, parish clerk 4
5584908 2530359 2530359 defendant Shiphard John tailor 609035 609035 Shiphard, John, of Portbury, tailor 0
5585473 2530524 2530524 defendant Shiphard John tailor 609035 609035 Shiphard, John, of Portbury, tailor 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);