names

45 rows where place_id = 587286

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590992 1864808 1864808 defendant Berwyke Thomas husbandman 587286 587286 Berwyke, Thomas, of Camelford, husbandman 0
3680995 1920134 1920134 defendant Gobell William mercer 587286 587286 Gobell, William, of Camelford, mercer 3
3720500 1932694 1932694 defendant Renold Thomas gent 587286 587286 Renold, Thomas, of Camelford, gent 0
3736281 1937587 1937587 defendant Renold Thomas gent 587286 587286 Renold, Thomas, of Camelford, gent 0
3774318 1949688 1949688 defendant Fourde John husbandman 587286 587286 Fourde, John, of Camelford, husbandman 1
3860567 1977028 1977028 defendant Holman John smith 587286 587286 Holman, John, of Camelford, smith 1
3926221 1999092 1999092 defendant Cocke Christopher yeoman 587286 587286 Cocke, Christopher, of Camelford, yeoman 0
3949143 2006765 2006765 defendant Hendye Humphrey yeoman 587286 587286 Hendye, Humphrey, of Camelford, yeoman 0
3974715 2015724 2015724 defendant Hendy Humphrey yeoman 587286 587286 Hendy, Humphrey, of Camelford, yeoman 0
4109081 2063504 2063504 defendant Cocke John esq 587286 587286 Cocke, John, of Camelford, esq 0
4217916 2101757 2101757 defendant Cooke John esq 587286 587286 Cooke, John, of Camelford, esq 0
4287478 2125574 2125574 defendant Cock John esq 587286 587286 Cock, John, of Camelford, esq 0
4331735 2140909 2140909 defendant Cocke Christopher gent 587286 587286 Cocke, Christopher, of Camelford, gent 3
4609433 2234050 2234050 defendant Shad John   587286 587286 Shad, John, of Camelford 0
4666472 2250992 2250992 defendant Morley William husbandman 587286 587286 Morley, William, of Camelford, husbandman 0
4679240 2259114 2259114 defendant Orvell John husbandman 587286 587286 Orvell, John, of Camelford, husbandman 4
4694388 2263743 2263743 defendant Person John smith 587286 587286 Person, John, of Camelford, smith 0
4694389 2263743 2263743 defendant Schad John husbandman 587286 587286 Schad, John, of Camelford, husbandman 1
4695715 2264140 2264140 defendant Person John smith 587286 587286 Person, John, of Camelford, smith 0
4695716 2264140 2264140 defendant Schad John husbandman 587286 587286 Schad, John, of Camelford, husbandman 1
4732924 2275476 2275476 defendant Puddyng John gent 587286 587286 Puddyng, John, of Camelford, gent 0
4822539 2303124 2303124 defendant Perys Thomas husbandman 587286 587286 Perys, Thomas, of Camelford, husbandman 0
4873834 2318755 2318755 defendant Edward William husbandman 587286 587286 Edward, William, of Camelford, husbandman 1
4899831 2326585 2326585 defendant Gylle John husbandman 587286 587286 (Gylle, John, of Camelford, husbandman 6
4936384 2337770 2337770 defendant Piers Thomas husbandman 587286 587286 Piers, Thomas, of Camelford, husbandman 2
4978549 2350536 2350536 plaintiff Ronek or Rovek Thomas   587286 587286 Ronek or Rovek, Thomas, of Camelford 0
5005473 2358503 2358503 plaintiff Ronell or Rovell Thomas   587286 587286 Ronell or Rovell, Thomas, of Camelford 0
5048584 2371219 2371219 plaintiff Ronell or Rovell Thomas   587286 587286 Ronell or Rovell, Thomas, of Camelford 0
5052640 2372382 2372382 defendant Flanche John dyer 587286 587286 Flanche, John, of Camelford, dyer 0
5074410 2378849 2378849 defendant Flaunche Richard mercer 587286 587286 Flaunche, Richard, of Camelford, mercer 0
5246047 2429010 2429010 defendant Flaunche John husbandman 587286 587286 Flaunche, John, of Camelford, husbandman 1
5246053 2429011 2429011 defendant Flaunche John husbandman 587286 587286 Flaunche, John, of Camelford, husbandman 1
5350812 2460364 2460364 defendant Brenton David chaplain 587286 587286 Brenton, David, of Camelford, chaplain 1
5350813 2460364 2460364 defendant Mely John tailor 587286 587286 Mely, John, of Camelford, tailor 2
5350814 2460364 2460364 defendant Laurens John tailor 587286 587286 together with Laurens, John, of Camelford, tailor 3
5350815 2460364 2460364 defendant Arkesworthy Robert husbandman 587286 587286 Arkesworthy, Robert, of Camelford, husbandman 4
5350816 2460364 2460364 defendant Drewe John smith 587286 587286 Drewe, John, of Camelford, smith 5
5382332 2470005 2470005 defendant Rawelyn Michael   587286 587286 Rawelyn, Michael, of Camelford 3
5400436 2475194 2475194 defendant Pernell John husbandman 587286 587286 Pernell, John, of Camelford, husbandman 1
5404402 2476331 2476331 defendant Rawelyn Michael yeoman 587286 587286 (Rawelyn, Michael, of Camelford, yeoman 3
5428752 2483511 2483511 defendant Pernell John husbandman 587286 587286 Pernell, John, of Camelford, husbandman 0
5494409 2503232 2503232 defendant Rovell or Ronell Thomas gent 587286 587286 Rovell or Ronell, Thomas, of Camelford, gent 0
5588444 2531392 2531392 defendant Cok John yeoman 587286 587286 Cok, John, of Camelford, yeoman 0
5588446 2531393 2531393 defendant Cok John yeoman 587286 587286 Cok, John, of Camelford, yeoman 0
5624416 2551579 2551579 defendant Wade John tailor 587286 587286 Wade, John, of Camelford, tailor 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);