names

43 rows where place_id = 585968

✎ 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
3587600 1863769 1863769 defendant Wryght William butcher 585968 585968 Wryght, William, of Beclys, butcher 1
3587601 1863769 1863769 defendant Terry Henry weaver 585968 585968 Terry, Henry, of Beclys, weaver 2
3593978 1865755 1865755 defendant Birlyngham Thomas raffman 585968 585968 Birlyngham, Thomas, of Beclys, raffman 4
3635553 1905923 1905923 defendant Payne Alexander gent 585968 585968 Payne, Alexander, of Beclys, gent 0
3680248 1919894 1919894 plaintiff Rede William merchant 585968 585968 Rede, William, of Beclys, merchant 0
3828535 1966799 1966799 defendant Gatis Richard tailor 585968 585968 Gatis, Richard, of Beclys, tailor 1
3838313 1969899 1969899 defendant Bradley John tanner 585968 585968 Bradley, John, of Beclys, tanner 0
3880782 1983838 1983838 plaintiff Rede Thomas   585968 585968 Rede, Thomas, of Beclys 0
3908675 1993197 1993197 defendant Yaxley Thomas clerk 585968 585968 Yaxley, Thomas, of Beclys, clerk 0
4466002 2190025 2190025 defendant Welles Edmund   585968 585968 Welles, Edmund, of Beclys, parson 2
4517178 2205775 2205775 defendant Cutelere John   585968 585968 Cutelere, John, of Beclys 1
4517180 2205775 2205775 defendant Haton Henry   585968 585968 Haton, Henry, of Beclys 3
4551808 2216510 2216510 plaintiff Ely William master & parson 585968 585968 Ely, William, of Beclys, master & parson 0
4557615 2218315 2218315 defendant Ersham William   585968 585968 Ersham, William, of Beclys 5
4607026 2233311 2233311 plaintiff Baxtere John   585968 585968 Baxtere, John, of Beclys 0
4636164 2242144 2242144 defendant Weynflet John   585968 585968 Weynflet, John, of Beclys 1
4720156 2271647 2271647 defendant Danby Robert mercer 585968 585968 Danby, Robert, of Beclys, mercer 1
4724162 2272850 2272850 defendant Benet Thomas yeoman 585968 585968 Benet, Thomas, of Beclys, yeoman 0
4735993 2276401 2276401 defendant Clerk Thomas yeoman 585968 585968 Clerk, Thomas, of Beclys, yeoman 5
4739329 2277387 2277387 defendant Baxter John yeoman 585968 585968 Baxter, John, of Beclys, yeoman 0
4754451 2281771 2281771 defendant Hunte Thomas reeder 585968 585968 Hunte, Thomas, of Beclys, reeder 0
4754453 2281771 2281771 defendant Crowe John baker 585968 585968 Crowe, John, of Beclys, baker 2
4777374 2288916 2288916 defendant Crosse John husbandman 585968 585968 Crosse, John, of Beclys, husbandman 0
4934673 2337235 2337235 defendant Story William painter 585968 585968 Story, William, of Beclys, painter 1
4940957 2339196 2339196 defendant Dobget John fletcher 585968 585968 Dobget, John, of Beclys, fletcher 0
5058720 2374173 2374173 defendant Comyn William butcher 585968 585968 Comyn, William, of Beclys, butcher 0
5090876 2383723 2383723 defendant Makell Alexander carpenter 585968 585968 Makell, Alexander, of Beclys, carpenter 0
5101643 2386904 2386904 defendant Wyske Alan butcher 585968 585968 Wyske, Alan, of Beclys, butcher 0
5101645 2386904 2386904 defendant Tomsone John butcher 585968 585968 Tomsone, John, of Beclys, butcher 2
5101646 2386904 2386904 defendant Cock John butcher 585968 585968 Cock, John, of Beclys, butcher 3
5133573 2396311 2396311 defendant Poule John roper 585968 585968 Poule, John, of Beclys, roper 0
5142917 2399058 2399058 defendant Walpole William sawyer 585968 585968 Walpole, William, of Beclys, sawyer 0
5230389 2424505 2424505 plaintiff Banyard John esq 585968 585968 Banyard, John, of Beclys, esq 0
5230397 2424506 2424506 plaintiff Banyard John esq 585968 585968 Banyard, John, of Beclys, esq 0
5312555 2448787 2448787 defendant Parys Thomas butcher 585968 585968 Parys, Thomas, of Beclys, butcher 3
5323682 2452169 2452169 defendant Davy Richard husbandman 585968 585968 Davy, Richard, of Beclys, husbandman 1
5334846 2455490 2455490 defendant Weve or Wene William carpenter 585968 585968 Weve or Wene, William, of Beclys, carpenter 3
5334914 2455511 2455511 defendant Vaux Robert yeoman 585968 585968 Vaux, Robert, of Beclys, yeoman 2
5390354 2472305 2472305 defendant Byrlyngham Thomas   585968 585968 Byrlyngham, Thomas, of Beclys, , tallow chandler 10
5390355 2472305 2472305 defendant Baker John husbandman 585968 585968 Baker, John, of Beclys, husbandman 11
5482606 2499738 2499738 defendant Hill Robert husbandman 585968 585968 Hill, Robert, of Beclys, husbandman 0
5550394 2520135 2520135 defendant Fraunceys Robert yeoman 585968 585968 Fraunceys, Robert, of Beclys, yeoman 0
5589301 2531657 2531657 plaintiff Rede William merchant 585968 585968 Rede, William, of Beclys, merchant 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);