names

44 rows where place_id = 601640

✎ 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
3646333 1909245 1909245 defendant Baynbryg Reginald   601640 601640 Baynbryg, Reginald, of Helton 0
3724136 1933832 1933832 defendant Wellys William carver 601640 601640 Wellys, William, of Helton, carver 0
3940933 2003975 2003975 defendant Clerke Roger husbandman 601640 601640 Clerke, Roger, of Helton, husbandman 1
3981673 2018202 2018202 defendant Mapowder Thomas yeoman 601640 601640 Mapowder, Thomas, of Helton, yeoman 0
4021630 2032463 2032463 defendant Glide Roger husbandman 601640 601640 Glide, Roger, of Helton, husbandman 2
4035021 2037207 2037207 plaintiff Helton or Hylton Thomas gent 601640 601640 Helton or Hylton, Thomas, of Helton, gent 0
4110477 2064010 2064010 plaintiff Sawle Roger (legal representative) 601640 601640 Sawle, Roger, of Helton, yeoman, executor of 0
4122911 2068492 2068492 defendant Morrys Robert husbandman 601640 601640 Morrys, Robert, of Helton, husbandman 1
4157322 2080627 2080627 defendant Sawle alias Clarke Robert weaver 601640 601640 Sawle alias Clarke, Robert, of Helton, weaver 0
4157323 2080627 2080627 defendant Sawle alias Clarke Roger husbandman 601640 601640 Sawle alias Clarke, Roger, of Helton, husbandman 1
4157324 2080627 2080627 defendant Burden Walter butcher 601640 601640 Burden, Walter, of Helton, butcher 2
4181071 2088854 2088854 defendant Banyster Richard butcher 601640 601640 Banyster, Richard, of Helton, butcher 1
4251117 2113352 2113352 defendant Morris Robert husbandman 601640 601640 Morris, Robert, of Helton, or of Aller, husbandman 1
4273311 2120635 2120635 defendant Michell William yeoman 601640 601640 Michell, William, of Helton, yeoman 0
4308913 2133268 2133268 defendant Stubye William husbandman 601640 601640 Stubye, William, of Helton, husbandman 0
4312099 2134371 2134371 defendant Whynell Richard blacksmith 601640 601640 Whynell, Richard, of Helton, blacksmith 1
4367821 2153542 2153542 defendant Carter George weaver 601640 601640 Carter, George, of Helton, weaver 2
4409551 2167791 2167791 defendant Sawle Roger baker 601640 601640 Sawle, Roger, of Helton, baker 0
4476802 2193408 2193408 defendant Smyth Edward   601640 601640 Smyth, Edward, of Helton 0
4476803 2193408 2193408 defendant Bailly Robert   601640 601640 Bailly, Robert, of Helton 1
4575727 2223918 2223918 defendant Baker John   601640 601640 Baker, John, of Helton 3
4611976 2234805 2234805 defendant Wyse Robert   601640 601640 Wyse, Robert, of Helton 0
4635121 2241831 2241831 plaintiff Wyse John   601640 601640 Wyse, John, of Helton 0
4677820 2258679 2258679 plaintiff Helton John de   601640 601640 Helton, John de, of Helton 0
4702442 2266174 2266174 plaintiff Hake John   601640 601640 Hake, John, of Helton 0
4718525 2271134 2271134 defendant Smyth Robert smith 601640 601640 Smyth, Robert, of Helton, smith 3
4722134 2272250 2272250 defendant Helton John esq 601640 601640 Helton, John, of Helton, esq 3
4819705 2302239 2302239 defendant Corbyn John   601640 601640 Corbyn, John, of Helton, groome 0
4861431 2314946 2314946 defendant Kendale John yeoman 601640 601640 Kendale, John, of Helton, yeoman 1
4875566 2319313 2319313 defendant Pegeon John clerk 601640 601640 Pegeon, John, of Helton, clerk 0
4949286 2341762 2341762 defendant Glamvyle Richard smith 601640 601640 Glamvyle, Richard, of Helton, smith 0
4966221 2346830 2346830 defendant Benyght John yeoman 601640 601640 Benyght, John, of Helton, yeoman 1
5061280 2374958 2374958 defendant Harryes John husbandman 601640 601640 Harryes, John, of Helton, husbandman 3
5110973 2389603 2389603 defendant Hikson Hugh husbandman 601640 601640 Hikson, Hugh, of Helton, husbandman 0
5177726 2409187 2409187 defendant Harryson Nicholas yeoman 601640 601640 Harryson, Nicholas, of Helton, yeoman 0
5377866 2468654 2468654 defendant Machyn John husbandman 601640 601640 Machyn, John, of Helton, husbandman 0
5414456 2479261 2479261 defendant Derke John butcher 601640 601640 Derke, John, of Helton, butcher 2
5422629 2481720 2481720 defendant Blencarn John husbandman 601640 601640 Blencarn, John, of Helton, husbandman 4
5430257 2483987 2483987 defendant Derke John butcher 601640 601640 Derke, John, of Helton, butcher 1
5447063 2489010 2489010 defendant Derke John butcher 601640 601640 Derke, John, of Helton, butcher 1
5459505 2492755 2492755 defendant Derke John butcher 601640 601640 Derke, John, of Helton, butcher 1
5523293 2512117 2512117 defendant Heyward Thomas husbandman 601640 601640 Heyward, Thomas, of Helton, husbandman 0
5588601 2531441 2531441 defendant Brache Alice widow 601640 601640 Brache, Alice, of Helton, widow 1
5596047 2533677 2533677 defendant Miller Thomas husbandman 601640 601640 Miller, Thomas, of Helton, husbandman 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);