names

46 rows where place_id = 669220

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3989612 2021031 2021031 defendant Pepys Thomas (legal representative) 669220 669220 Pepys, Thomas, of South Creake, gent, executors of 0
3992254 2021995 2021995 plaintiff Buntynge Thomas singleman 669220 669220 Buntynge, Thomas, of South Creake, singleman 0
3996367 2023454 2023454 defendant Pepys Thomas (legal representative) 669220 669220 Pepys, Thomas, of South Creake, gent, executors of 0
3996371 2023455 2023455 defendant Pepys Thomas (legal representative) 669220 669220 Pepys, Thomas, of South Creake, gent, executors of 0
3996373 2023455 2023455 defendant Norton Richard gent 669220 669220 Norton, Richard, of South Creake, gent 2
4009294 2028089 2028089 defendant Peapes Thomas (legal representative) 669220 669220 Peapes, Thomas, of South Creake, gent, executors of 0
4009295 2028089 2028089 defendant Mansner Richard gent 669220 669220 (Mansner, Richard, of South Creake, gent 1
4009296 2028089 2028089 defendant Norton Richard gent 669220 669220 Norton, Richard, of South Creake, gent 2
4009563 2028188 2028188 defendant Mansner Richard gent 669220 669220 (Mansner, Richard, of South Creake, gent 1
4009564 2028188 2028188 defendant Norton Richard gent 669220 669220 Norton, Richard, of South Creake, gent 2
4010816 2028645 2028645 plaintiff Peapes Thomas (legal representative) 669220 669220 Peapes, Thomas, of South Creake, gent, administrator of 0
4014520 2029918 2029918 defendant Peapes Thomas (legal representative) 669220 669220 Peapes, Thomas, of South Creake, gent, executor of 0
4014521 2029918 2029918 defendant Manser Richard gent 669220 669220 (Manser, Richard, of South Creake, gent 1
4014522 2029918 2029918 defendant Norton Richard gent 669220 669220 Norton, Richard, of South Creake, gent 2
4028806 2034951 2034951 plaintiff Cowper Robert yeoman 669220 669220 Cowper, Robert, of South Creake, yeoman 0
4096665 2059134 2059134 defendant Cowper Roger (legal representative) 669220 669220 Cowper, Roger, of South Creake, merchant, executor of 0
4099887 2060284 2060284 defendant Pepys Dermer gent 669220 669220 Pepys, Dermer, of South Creake, gent 0
4099888 2060284 2060284 defendant Manser Richard gent 669220 669220 Manser, Richard, of South Creake, gent 1
4144296 2076167 2076167 defendant Peapys Thomas gent 669220 669220 Thomas Peapys, of South Creake, gent, executors of 0
4144297 2076167 2076167 defendant Peapes Firmarius or Farmer gent 669220 669220 (Peapes, Firmarius or Farmer, of South Creake, gent, son of Thomas Peapes or Pepys, of South Creake, gent 1
4144298 2076167 2076167 defendant Manser Richard gent 669220 669220 Manser, Richard, of South Creake, gent 2
4144300 2076167 2076167 defendant Peapes John gent 669220 669220 Peapes, John, of South Creake, gent 4
4154407 2079633 2079633 defendant Harte John clerk 669220 669220 Harte, John, of South Creake, clerk 0
4157822 2080812 2080812 defendant Pepys Fermer gent 669220 669220 Pepys, Fermer, of South Creake, gent 0
4175849 2087028 2087028 defendant Bolter Richard gent 669220 669220 Bolter, Richard, of South Creake, gent 0
4175850 2087028 2087028 defendant Mychell Robert husbandman 669220 669220 Mychell, Robert, of South Creake, husbandman 1
4175851 2087028 2087028 defendant Sompter Edmund husbandman 669220 669220 Sompter, Edmund, of South Creake, husbandman 2
4185194 2090328 2090328 defendant Bolter Richard gent 669220 669220 Bolter, Richard, of South Creake, gent 0
4192566 2092962 2092962 defendant Peapes Thomas (legal representative) 669220 669220 Peapes, Thomas, of South Creake, gent, executors of 0
4192567 2092962 2092962 defendant Manser Richard gent 669220 669220 (Manser, Richard, of South Creake, gent 1
4192568 2092962 2092962 defendant Norton Richard gent 669220 669220 Norton, Richard, of South Creake, gent 2
4192569 2092962 2092962 defendant Peapes John gent 669220 669220 together with Peapes, John, of South Creake, gent 3
4207609 2098219 2098219 defendant Bowlter Richard gent 669220 669220 Bowlter, Richard, of South Creake, gent 0
4218510 2101972 2101972 defendant Grene Richard mariner 669220 669220 Grene, Richard, of South Creake, mariner 0
4218511 2101972 2101972 defendant Grene William husbandman 669220 669220 Grene, William, of South Creake, husbandman 1
4234029 2107427 2107427 defendant Cunningham John yeoman 669220 669220 together with Cunningham, John, of South Creake, yeoman 1
4234030 2107427 2107427 defendant Ducke Thomas yeoman 669220 669220 Ducke, Thomas, of South Creake, yeoman 2
4240551 2109822 2109822 defendant Mott Martin husbandman 669220 669220 Mott, Martin, of South Creake, husbandman 0
4240552 2109822 2109822 defendant Barker Thomas yeoman 669220 669220 Barker, Thomas, of South Creake, yeoman 1
4240555 2109823 2109823 defendant Mott Martin husbandman 669220 669220 Mott, Martin, of South Creake, husbandman 0
4240556 2109823 2109823 defendant Barker Thomas yeoman 669220 669220 Barker, Thomas, of South Creake, yeoman 1
4261974 2116956 2116956 defendant Pepis Fermar gent 669220 669220 Pepis, Fermar, of South Creake, gent 2
4289104 2126159 2126159 defendant Mangye or Maugye John yeoman 669220 669220 Mangye or Maugye, John, of South Creake, yeoman 2
4319678 2136995 2136995 defendant Hudson James tailor 669220 669220 Hudson, James, of South Creake, tailor 1
4319679 2136995 2136995 defendant Dowe Robert yeoman 669220 669220 Dowe, Robert, of South Creake, yeoman 2
4359895 2150703 2150703 defendant Mangey or Maugey John yeoman 669220 669220 Mangey or Maugey, John, of South Creake, yeoman 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);