names

39 rows where place_id = 604202

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3657186 1912513 1912513 defendant Cotyngham Robert husbandman 604202 604202 Cotyngham, Robert, of Cadney, husbandman 0
3672043 1917257 1917257 defendant Pye Henry husbandman 604202 604202 Pye, Henry, of Cadney, husbandman 2
3746863 1940936 1940936 defendant Loker Robert laborer 604202 604202 Loker, Robert, of Cadney, laborer 6
3872069 1980889 1980889 defendant Scowsyn John husbandman 604202 604202 Scowsyn, John, of Cadney, husbandman 0
3872070 1980889 1980889 defendant Tomeson Peter laborer 604202 604202 Tomeson, Peter, of Cadney, laborer 1
3872071 1980889 1980889 defendant Dell Lawrence   604202 604202 Dell, Lawrence, of Cadney 2
3872072 1980889 1980889 defendant Madynwell Thomas husbandman 604202 604202 Madynwell, Thomas, of Cadney, husbandman 3
4088994 2056362 2056362 defendant Bell Robert husbandman 604202 604202 Bell, Robert, of Cadney, husbandman 1
4112396 2064692 2064692 defendant Ayston James yeoman 604202 604202 Ayston, James, of Cadney, yeoman 1
4114589 2065507 2065507 defendant Pearsey Francis clerk 604202 604202 Pearsey, Francis, of Cadney, clerk 0
4114590 2065507 2065507 defendant Smythe Christopher husbandman 604202 604202 Smythe, Christopher, of Cadney, husbandman 1
4114591 2065507 2065507 defendant Smythe Richard husbandman 604202 604202 Smythe, Richard, of Cadney, husbandman 2
4121868 2068119 2068119 defendant Croskill Edward yeoman 604202 604202 Croskill, Edward, of Cadney, yeoman 1
4121878 2068122 2068122 defendant Wrighte John husbandman 604202 604202 Wrighte, John, of Cadney, husbandman 2
4121879 2068122 2068122 defendant Welmayde Silvester husbandman 604202 604202 Welmayde, Silvester, of Cadney, husbandman 3
4137197 2073650 2073650 defendant South Philip yeoman 604202 604202 South, Philip, of Cadney, yeoman 0
4286676 2125283 2125283 defendant Kyng Thomas husbandman 604202 604202 Kyng, Thomas, of Cadney, husbandman 0
4286677 2125283 2125283 defendant Tomson Mathew tailor 604202 604202 Tomson, Mathew, of Cadney, tailor 1
4299940 2130073 2130073 defendant Kinge Thomas husbandman 604202 604202 Kinge, Thomas, of Cadney, husbandman 0
4347034 2146219 2146219 defendant Waters Thomas miller 604202 604202 Waters, Thomas, of Cadney, miller 1
4367784 2153531 2153531 defendant Foxe John yeoman 604202 604202 Foxe, John, of Cadney, yeoman 0
4887190 2322837 2322837 plaintiff Ousteby John husbandman 604202 604202 Ousteby, John, of Cadney, husbandman 0
5054340 2372876 2372876 defendant Couper John cooper 604202 604202 Couper, John, of Cadney, cooper 4
5152190 2401778 2401778 defendant Sygworth William husbandman 604202 604202 Sygworth, William, of Cadney, husbandman 2
5152192 2401778 2401778 defendant Kelsterne Stephen husbandman 604202 604202 Kelsterne, Stephen, of Cadney, husbandman 4
5152193 2401778 2401778 defendant Fayrebarn Thomas husbandman 604202 604202 Fayrebarn, Thomas, of Cadney, husbandman 5
5152194 2401778 2401778 defendant Nevyll Richard husbandman 604202 604202 Nevyll, Richard, of Cadney, husbandman 6
5152195 2401778 2401778 defendant Wright William husbandman 604202 604202 Wright, William, of Cadney, husbandman 7
5152196 2401778 2401778 defendant Wryght Thomas husbandman 604202 604202 Wryght, Thomas, of Cadney, husbandman 8
5170063 2406980 2406980 defendant Sygworth William husbandman 604202 604202 Sygworth, William, of Cadney, husbandman 2
5170065 2406980 2406980 defendant Kelsterne Stephen husbandman 604202 604202 Kelsterne, Stephen, of Cadney, husbandman 4
5170066 2406980 2406980 defendant Fayrebarn Thomas husbandman 604202 604202 Fayrebarn, Thomas, of Cadney, husbandman 5
5170067 2406980 2406980 defendant Nevyll Richard husbandman 604202 604202 Nevyll, Richard, of Cadney, husbandman 6
5170068 2406980 2406980 defendant Wright Robert husbandman 604202 604202 Wright, Robert, of Cadney, husbandman 7
5170069 2406980 2406980 defendant Belle John husbandman 604202 604202 Belle, John, of Cadney, husbandman 8
5170070 2406980 2406980 defendant Wright William husbandman 604202 604202 Wright, William, of Cadney, husbandman 9
5170071 2406980 2406980 defendant Wright Thomas husbandman 604202 604202 Wright, Thomas, of Cadney, husbandman 10
5227474 2423663 2423663 defendant Broune William yeoman 604202 604202 Broune, William,of Cadney, yeoman 0
5486542 2500866 2500866 defendant Pecop or Petop Lawrence weaver 604202 604202 Pecop or Petop, Lawrence, of Cadney, weaver 2

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);