names

28 rows where place_id = 598109

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3631166 1904570 1904570 defendant Assheby Robert husbandman 598109 598109 Assheby, Robert, of Pulham St Mary Magdalene, husbandman 0
3758131 1944530 1944530 plaintiff Broun John raffman 598109 598109 Broun, John, of Pulham St Mary Magdalene, raffman 0
3814232 1962358 1962358 defendant Everard Robert butcher 598109 598109 Everard, Robert, of Pulham St Mary Magdalene, butcher 0
3923148 1998048 1998048 defendant Wyllyamson William husbandman 598109 598109 Wyllyamson, William, of Pulham St Mary Magdalene, husbandman 2
3927917 1999676 1999676 defendant Wryght Thomas turner 598109 598109 Wryght, Thomas, of Pulham St Mary Magdalene, turner 0
3927984 1999695 1999695 defendant Sherman Richard yeoman 598109 598109 Sherman, Richard, of Pulham St Mary Magdalene, yeoman 0
3972273 2014867 2014867 defendant Buck William   598109 598109 Buck, William, of Pulham St Mary Magdalene, organ maker 0
3972274 2014867 2014867 defendant Palgrave Thomas yeoman 598109 598109 Palgrave, Thomas, of Pulham St Mary Magdalene, yeoman 1
3976512 2016360 2016360 defendant Leman Paul yeoman 598109 598109 Leman, Paul, of Pulham St Mary Magdalene, yeoman 0
3986807 2020023 2020023 defendant Dawes John husbandman 598109 598109 Dawes, John, of Pulham St Mary Magdalene, husbandman 0
3986808 2020023 2020023 defendant Bevans Richard butcher 598109 598109 Bevans, Richard, of Pulham St Mary Magdalene, butcher 1
3990115 2021220 2021220 plaintiff Belward Robert, junior   598109 598109 Belward, Robert, junior, of Pulham St Mary Magdalene 0
3990117 2021221 2021221 plaintiff Belward Robert, junior   598109 598109 Belward, Robert, junior, of Pulham St Mary Magdalene 0
3990119 2021222 2021222 plaintiff Belward Robert, junior   598109 598109 Belward, Robert, junior, of Pulham St Mary Magdalene 0
3990121 2021223 2021223 plaintiff Belward Robert, junior   598109 598109 Belward, Robert, junior, of Pulham St Mary Magdalene 0
4023945 2033270 2033270 plaintiff Bellward Robert   598109 598109 Bellward, Robert, of Pulham St Mary Magdalene 0
4023971 2033277 2033277 plaintiff Belward Robert, junior   598109 598109 Belward, Robert, junior, of Pulham St Mary Magdalene 0
4073203 2050707 2050707 defendant Johnson William butcher 598109 598109 Johnson, William, of Pulham St Mary Magdalene, butcher 0
4100799 2060601 2060601 defendant Write Thomas tanner 598109 598109 Write, Thomas, of Pulham St Mary Magdalene, tanner 2
4143925 2076040 2076040 defendant Keryson Robert husbandman 598109 598109 Keryson, Robert, of Pulham St Mary Magdalene, husbandman 0
4197822 2094793 2094793 defendant Davys John yeoman 598109 598109 Davys, John, of Pulham St Mary Magdalene, yeoman 2
4202196 2096312 2096312 defendant Botye Robert yeoman 598109 598109 Botye, Robert, of Pulham St Mary Magdalene, yeoman 0
4202198 2096313 2096313 defendant Botye Robert yeoman 598109 598109 Botye, Robert, of Pulham St Mary Magdalene, yeoman 0
4280106 2122952 2122952 defendant Swanton Robert cooper 598109 598109 Swanton, Robert, of Pulham St Mary Magdalene, cooper 1
4319534 2136944 2136944 defendant Leman John husbandman 598109 598109 Leman, John, of Pulham St Mary Magdalene, husbandman 2
4319535 2136944 2136944 defendant Leman Robert husbandman 598109 598109 Leman, Robert, of Pulham St Mary Magdalene, husbandman 3
4345442 2145677 2145677 defendant Crane John, senior yeoman 598109 598109 Crane, John, senior, of Pulham St Mary Magdalene, yeoman 0
4374874 2156070 2156070 defendant Stone John weaver 598109 598109 Stone, John, of Pulham St Mary Magdalene, weaver 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);