names

49 rows where place_id = 592583

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608172 1870211 1870211 defendant Elyotte William esq 592583 592583 Elyotte, William, of Denham, Bucks, esq 0
3608174 1870212 1870212 defendant Elyotte William esq 592583 592583 Elyotte, William, of Denham, Bucks, esq 0
3630249 1904309 1904309 defendant Bedell Thomas husbandman 592583 592583 Bedell, Thomas, of Denham, Bucks, husbandman 0
3651568 1910844 1910844 defendant Duredent George gent 592583 592583 Duredent, George, of Denham, Bucks, gent 0
3697455 1925423 1925423 defendant Gryffyn Thomas yeoman 592583 592583 Gryffyn, Thomas, of Denham, Bucks, yeoman 1
3840467 1970579 1970579 defendant Tredwey John husbandman 592583 592583 Tredwey, John, of Denham, Bucks, husbandman 1
3840473 1970580 1970580 defendant Tredwey John husbandman 592583 592583 Tredwey, John, of Denham, Bucks, husbandman 1
3858006 1976152 1976152 plaintiff Bedyll Thomas yeoman 592583 592583 Bedyll, Thomas, of Denham, Bucks, yeoman 0
3928909 2000008 2000008 plaintiff Warde John   592583 592583 Warde, John, of Denham, Bucks 1
3928915 2000009 2000009 plaintiff Warde John   592583 592583 Warde, John, of Denham, Bucks 1
3977164 2016582 2016582 defendant Sterne Thomas   592583 592583 Sterne, Thomas, of Denham, Bucks, gent, servant to Sir Edmund Pakham 2
3984894 2019354 2019354 defendant Peckham George esq 592583 592583 Peckham, George, of Denham, Bucks, or of London, esq 0
4009816 2028286 2028286 defendant Peckham George   592583 592583 Peckham, George, of Denham, Bucks, knight 0
4042779 2039890 2039890 plaintiff Peckham George   592583 592583 Peckham, George, of Denham, Bucks, knight 0
4125319 2069340 2069340 defendant Peckham George   592583 592583 Peckham, George, of Denham, Bucks, knight 0
4155251 2079930 2079930 defendant Peckham George   592583 592583 Peckham, George, of Denham, Bucks, knight 0
4178172 2087836 2087836 defendant Peckham Edmund esq 592583 592583 Peckham, Edmund, of Denham, Bucks, esq 0
4209750 2098966 2098966 defendant Peckham George   592583 592583 Peckham, George, of Denham, Bucks, knight 0
4269128 2119268 2119268 defendant Smewen John husbandman 592583 592583 Smewen, John, of Denham, Bucks, husbandman 1
4303120 2131220 2131220 defendant Swansey Edmund yeoman 592583 592583 Swansey, Edmund, of Denham, Bucks, yeoman 0
4305103 2131926 2131926 defendant Nutkyn Henry miller 592583 592583 Nutkyn, Henry, of Denham, Bucks, miller 0
4349192 2146978 2146978 defendant Sympson Richard gent 592583 592583 Sympson, Richard, of Denham, Bucks, gent 0
4407064 2166921 2166921 defendant Gryffythe Edward yeoman 592583 592583 Gryffythe, Edward, of Denham, Bucks, yeoman 1
4864746 2315946 2315946 defendant Holwey Thomas   592583 592583 Holwey, Thomas, of Denham, Bucks, millward 1
4970629 2348153 2348153 defendant Gefferey John husbandman 592583 592583 Gefferey, John, of Denham, Bucks, husbandman 1
5003741 2357986 2357986 plaintiff Penneston John husbandman 592583 592583 Penneston, John, of Denham, Bucks, husbandman 0
5090376 2383566 2383566 defendant Grey Robert gent 592583 592583 Grey, Robert, of Denham, Bucks, gent 0
5111522 2389768 2389768 defendant Tylly Walter carpenter 592583 592583 Tylly, Walter, of Denham, Bucks, carpenter 0
5199822 2415697 2415697 defendant Harwell John (legal representative) 592583 592583 Harwell, John, of Denham, Bucks, administrator of 0
5260274 2433340 2433340 defendant Durdent Walter husbandman 592583 592583 Durdent, Walter, of Denham, Bucks, husbandman 0
5294039 2443230 2443230 defendant Carter Richard husbandman 592583 592583 Carter, Richard, of Denham, Bucks, husbandman 0
5296714 2444027 2444027 defendant Durdand William esq 592583 592583 Durdand, William, of Denham, Bucks, esq 0
5321699 2451564 2451564 defendant Durydent Walter esq 592583 592583 Durydent, Walter, of Denham, Bucks, esq 2
5326155 2452915 2452915 defendant Duredent Walter esq 592583 592583 Duredent, Walter, of Denham, Bucks, esq 2
5326159 2452916 2452916 defendant Duredent Walter esq 592583 592583 Duredent, Walter, of Denham, Bucks, esq 2
5326163 2452917 2452917 defendant Duredent Walter esq 592583 592583 Duredent, Walter, of Denham, Bucks, esq 2
5395325 2473737 2473737 defendant Harwell John husbandman 592583 592583 Harwell, John, of Denham, Bucks, husbandman 0
5408591 2477536 2477536 defendant Harwell John husbandman 592583 592583 Harwell, John, of Denham, Bucks, husbandman 0
5421818 2481462 2481462 defendant Hardwell John husbandman 592583 592583 Hardwell, John, of Denham, Bucks, husbandman 0
5421822 2481463 2481463 defendant Harwell John husbandman 592583 592583 Harwell, John, of Denham, Bucks, husbandman 0
5421826 2481464 2481464 defendant Harwell John husbandman 592583 592583 Harwell, John, of Denham, Bucks, husbandman 0
5501538 2505414 2505414 defendant Duraunt John gent 592583 592583 Duraunt, John, of Denham, Bucks, gent 0
5501541 2505415 2505415 defendant Dureaunt John gent 592583 592583 Dureaunt, John, of Denham, Bucks, gent 0
5527944 2513305 2513305 defendant Hatton George husbandman 592583 592583 Hatton, George, of Denham, Bucks, husbandman 1
5527952 2513307 2513307 defendant Hatton George husbandman 592583 592583 Hatton, George, of Denham, Bucks, husbandman 3
5553708 2521120 2521120 defendant Dordaunt Thomas gent 592583 592583 Dordaunt, Thomas, of Denham, Bucks, gent 0
5553714 2521122 2521122 defendant Dordaunt Thomas gent 592583 592583 Dordaunt, Thomas, of Denham, Bucks, gent 1
5566370 2524755 2524755 defendant Duredant Thomas, senior gent 592583 592583 Duredant, Thomas, senior, of Denham, Bucks, gent 0
5566373 2524756 2524756 defendant Duredant Thomas, senior gent 592583 592583 Duredant, Thomas, senior, of Denham, Bucks, gent 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);