names

47 rows where place_id = 597349

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628225 1903687 1903687 defendant Poryell John husbandman 597349 597349 Poryell, John, of Stykney, husbandman 0
3628227 1903687 1903687 defendant Egar Thomas husbandman 597349 597349 Egar, Thomas, of Stykney, husbandman 2
3630990 1904513 1904513 defendant Penyngton Adam gent 597349 597349 Penyngton, Adam, of Stykney, gent 0
3636520 1906215 1906215 defendant Barret John merchant 597349 597349 Barret, John, of Stykney, merchant 1
3636522 1906216 1906216 defendant Barret John merchant 597349 597349 Barret, John, of Stykney, merchant 0
3666586 1915488 1915488 defendant Chapman John husbandman 597349 597349 Chapman, John, of Stykney, husbandman 0
3690350 1923144 1923144 defendant CLerk Robert yeoman 597349 597349 CLerk, Robert, of Stykney, yeoman 3
3695055 1924663 1924663 defendant Myssenden Barnard gent 597349 597349 Myssenden, Barnard, of Stykney, gent 0
3695165 1924709 1924709 defendant Penyngton Adam esq 597349 597349 Penyngton, Adam, of Stykney, esq 0
3709028 1929120 1929120 defendant Myssenden Barnard gent 597349 597349 Myssenden, Barnard, of Stykney, gent 0
3723633 1933665 1933665 defendant Myssenden Barnard gent 597349 597349 Myssenden, Barnard, of Stykney, gent 0
3730412 1935744 1935744 defendant Chapman John fisher 597349 597349 Chapman, John, of Stykney, fisher 0
3730419 1935745 1935745 defendant Chapman John fisher 597349 597349 Chapman, John, of Stykney, fisher 2
3739454 1938548 1938548 defendant Myssenden Barnard gent 597349 597349 Myssenden, Barnard, of Stykney, gent 0
3739727 1938636 1938636 defendant Chapman John fisher 597349 597349 Chapman, John, of Stykney, fisher 0
3739729 1938637 1938637 defendant Chapman John fisher 597349 597349 Chapman, John, of Stykney, fisher 0
3771345 1948729 1948729 defendant Gybbe Richard clerk 597349 597349 Gybbe, Richard, of Stykney, clerk 0
3800340 1958025 1958025 defendant Bell William fisher 597349 597349 Bell, William, of Stykney, fisher 0
3879591 1983426 1983426 defendant Goodwyn William husbandman 597349 597349 Goodwyn, William, of Stykney, husbandman 0
3896132 1988910 1988910 defendant Parleben Rise laborer 597349 597349 Parleben, Rise, of Stykney, laborer 0
3902505 1991069 1991069 defendant Egar John yeoman 597349 597349 Egar, John, of Stykney, yeoman 0
3929764 2000294 2000294 defendant Burden Robert yeoman 597349 597349 Burden, Robert, of Stykney, yeoman 0
3931488 2000831 2000831 defendant Chapman Richard yeoman 597349 597349 Chapman, Richard, of Stykney, yeoman 0
3993220 2022319 2022319 defendant Brigg Anthony husbandman 597349 597349 Brigg, Anthony, of Stykney, husbandman 2
3996887 2023654 2023654 defendant Chapman Richard yeoman 597349 597349 Chapman, Richard, of Stykney, yeoman 1
3996888 2023654 2023654 defendant Brygg Anthony mercer 597349 597349 Brygg, Anthony, of Stykney, mercer 2
4173946 2086343 2086343 defendant Bowde Richard yeoman 597349 597349 Bowde, Richard, of Stykney, yeoman 2
4822646 2303159 2303159 defendant Werkeman Richard husbandman 597349 597349 Werkeman, Richard, of Stykney, husbandman 6
4973949 2349170 2349170 defendant Coleson Richard husbandman 597349 597349 Coleson, Richard, of Stykney, husbandman 0
5071213 2377887 2377887 defendant Baret John, junior husbandman 597349 597349 Baret, John, junior, of Stykney, husbandman 2
5288149 2441552 2441552 defendant Porell Robert husbandman 597349 597349 Porell, Robert, of Stykney, husbandman 2
5295357 2443637 2443637 defendant Hardy Thomas husbandman 597349 597349 Hardy, Thomas, of Stykney, husbandman 0
5295358 2443637 2443637 defendant Dalby Thomas fisher 597349 597349 Dalby, Thomas, of Stykney, fisher 1
5343299 2458098 2458098 defendant Wryght John husbandman 597349 597349 Wryght, John, of Stykney, husbandman 0
5343300 2458098 2458098 defendant Manby or Mauby John husbandman 597349 597349 Manby or Mauby, John, of Stykney, husbandman 1
5400269 2475150 2475150 defendant Dalby William husbandman 597349 597349 Dalby, William, of Stykney, husbandman 0
5435860 2485668 2485668 defendant Putterell Richard laborer 597349 597349 Putterell, Richard, of Stykney, laborer 0
5450347 2489990 2489990 defendant Stepyng Thomas husbandman 597349 597349 Stepyng, Thomas, of Stykney, husbandman 0
5450348 2489990 2489990 defendant Byker Joan widow 597349 597349 Byker, Joan, of Stykney, widow 1
5462492 2493688 2493688 defendant Dyker John widow 597349 597349 Dyker, John, of Stykney, widow 0
5575731 2527497 2527497 defendant Rabdyke Richard husbandman 597349 597349 Rabdyke, Richard, of Stykney, husbandman 0
5575732 2527497 2527497 defendant Rabdyke John husbandman 597349 597349 Rabdyke, John, of Stykney, husbandman 1
5575734 2527498 2527498 defendant Rabdyk Richard husbandman 597349 597349 Rabdyk, Richard, of Stykney, husbandman 0
5575735 2527498 2527498 defendant Rabdyk John husbandman 597349 597349 Rabdyk, John, of Stykney, husbandman 1
5596686 2533884 2533884 defendant Egre Thomas husbandman 597349 597349 Egre, Thomas, of Stykney, husbandman 0
5603723 2536032 2536032 defendant Parsons Robert husbandman 597349 597349 Parsons, Robert, of Stykney, husbandman 0
5605713 2536674 2536674 defendant Penyngton Adam gent 597349 597349 Penyngton, Adam, of Stykney, gent 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);