names

58 rows where place_id = 598873

✎ 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
3634403 1905559 1905559 defendant Robert Reginald smith 598873 598873 Robert, Reginald, of Wythyham, smith 0
3634404 1905559 1905559 defendant Plummer Denis smith 598873 598873 Plummer, Denis, of Wythyham, smith 1
3634405 1905559 1905559 defendant Frencheman Varlet smith 598873 598873 Frencheman, Varlet, of Wythyham, smith 2
3634406 1905559 1905559 defendant Frencheman William smith 598873 598873 Frencheman, William, of Wythyham, smith 3
3634407 1905559 1905559 defendant Frencheman Adam smith 598873 598873 Frencheman, Adam, of Wythyham, smith 4
3713483 1930528 1930528 defendant Raynold Quintin collier 598873 598873 Raynold, Quintin, of Wythyham, collier 4
3742074 1939389 1939389 defendant Sexpays Robert yeoman 598873 598873 Sexpays, Robert, of Wythyham, yeoman 1
3873151 1981237 1981237 defendant Tyeherst Richard yeoman 598873 598873 Tyeherst, Richard, of Wythyham, yeoman 0
3912462 1994496 1994496 plaintiff Alfrey Richard yeoman 598873 598873 Alfrey, Richard, of Wythyham, yeoman 0
3963797 2011940 2011940 plaintiff Alfrey Richard yeoman 598873 598873 Alfrey, Richard, of Wythyham, yeoman 0
3973596 2015336 2015336 plaintiff Gylbert John yeoman 598873 598873 Gylbert, John, of Wythyham, yeoman 0
3973599 2015337 2015337 plaintiff Gylbert John yeoman 598873 598873 Gylbert, John, of Wythyham,, yeoman 0
4023390 2033076 2033076 plaintiff Barrett Nicholas yeoman 598873 598873 Barrett, Nicholas, of Wythyham, yeoman 0
4024713 2033521 2033521 defendant Martyn Richard collier 598873 598873 Martyn, Richard, of Wythyham, collier 0
4024714 2033521 2033521 defendant Hayte William husbandman 598873 598873 Hayte, William, of Wythyham, husbandman 1
4024715 2033521 2033521 defendant A Kent John husbandman 598873 598873 A Kent, John, of Wythyham, husbandman 2
4033869 2036766 2036766 plaintiff Gylbert John yeoman 598873 598873 Gylbert, John, of Wythyham, yeoman 0
4033870 2036766 2036766 defendant Reade John yeoman 598873 598873 Reade, John, of Wythyham, yeoman 0
4053812 2043741 2043741 defendant Gylbart George yeoman 598873 598873 Gylbart, George, of Wythyham, yeoman 0
4064510 2047589 2047589 plaintiff Gylbart John (legal representative) 598873 598873 Gylbart, John, of Wythyham, yeoman, executor of 0
4064514 2047590 2047590 plaintiff Gylbart John (legal representative) 598873 598873 Gylbart, John, of Wythyham, yeoman, executor of 0
4064527 2047595 2047595 plaintiff Gylbert John, junior yeoman 598873 598873 Gylbert, John, junior, of Wythyham, yeoman 0
4075629 2051587 2051587 defendant Gylbert John (legal representative) 598873 598873 Gylbert, John, of Wythyham, yeoman, executor of 0
4094249 2058278 2058278 defendant Baydon Thomas husbandman 598873 598873 Baydon, Thomas, of Wythyham, husbandman 1
4096325 2059017 2059017 plaintiff Gylbert John yeoman 598873 598873 Gylbert, John, of Wythyham, yeoman 0
4098620 2059836 2059836 defendant Jones George gent 598873 598873 Jones, George, of Wythyham, gent 3
4131707 2071660 2071660 defendant Nevett Edward yeoman 598873 598873 Nevett, Edward, of Wythyham, yeoman 0
4149186 2077843 2077843 defendant Everhest Mathew   598873 598873 Everhest, Mathew, of Wythyham, "payle-" 0
4170786 2085273 2085273 defendant Wood Thomas husbandman 598873 598873 Wood, Thomas, of Wythyham, husbandman 2
4170787 2085273 2085273 defendant Hayward Peter husbandman 598873 598873 Hayward, Peter, of Wythyham, husbandman 3
4172743 2085925 2085925 defendant Jesop Paswater yeoman 598873 598873 Jesop, Paswater, of Wythyham, yeoman 1
4214299 2100518 2100518 defendant Bassett William yeoman 598873 598873 Bassett, William, of Wythyham, yeoman 0
4223860 2103831 2103831 defendant Maynard Richard yeoman 598873 598873 Maynard, Richard, of Wythyham, yeoman 0
4225189 2104279 2104279 defendant Bassett William yeoman 598873 598873 Bassett, William, of Wythyham, yeoman 3
4231335 2106460 2106460 defendant Maynarde Richard yeoman 598873 598873 Maynarde, Richard, of Wythyham, yeoman 0
4236379 2108296 2108296 defendant Maynard Richard yeoman 598873 598873 Maynard, Richard, of Wythyham, yeoman 0
4240740 2109883 2109883 defendant Maynard Richard yeoman 598873 598873 Maynard, Richard, of Wythyham, yeoman 0
4328411 2139818 2139818 defendant Bassett William yeoman 598873 598873 Bassett, William, of Wythyham, yeoman 0
4373991 2155769 2155769 defendant Rawlye or Rawlyns Thomas yeoman 598873 598873 Rawlye or Rawlyns, Thomas, of Wythyham, yeoman 1
4416881 2170150 2170150 defendant atte Hale William   598873 598873 atte Hale, William, of Wythyham 0
4564179 2220369 2220369 defendant Parmenter John   598873 598873 Parmenter, John, of Wythyham 0
4572028 2222819 2222819 defendant Skynner John   598873 598873 Skynner, John, of Wythyham 0
4572034 2222819 2222819 defendant Pope Thomas   598873 598873 Pope, Thomas, of Wythyham 6
4572053 2222825 2222825 defendant Skynner John   598873 598873 together with Skynner, John, of Wythyham 5
4664171 2250281 2250281 defendant Maynard William yeoman 598873 598873 Maynard, William, of Wythyham, yeoman 0
5005939 2358640 2358640 defendant Saxpays John laborer 598873 598873 Saxpays, John, of Wythyham, laborer 0
5005940 2358640 2358640 defendant Maynard John laborer 598873 598873 Maynard, John, of Wythyham, laborer 1
5129343 2395069 2395069 defendant Wotton Peter yeoman 598873 598873 Wotton, Peter, of Wythyham, yeoman 0
5148595 2400715 2400715 defendant Wotton Peter yeoman 598873 598873 Wotton, Peter, of Wythyham, yeoman 0
5167848 2406308 2406308 defendant Wotton Peter yeoman 598873 598873 Wotton, Peter, of Wythyham, yeoman 0
5183455 2410901 2410901 defendant Wotton Peter yeoman 598873 598873 Wotton, Peter, of Wythyham, yeoman 0
5183457 2410902 2410902 defendant Wotton Peter yeoman 598873 598873 Wotton, Peter, of Wythyham, yeoman 0
5279128 2438999 2438999 defendant Saxpayce Richard husbandman 598873 598873 Saxpayce, Richard, of Wythyham, husbandman 3
5279132 2438999 2438999 defendant Maynard John, senior husbandman 598873 598873 Maynard, John, senior, of Wythyham, husbandman 7
5279137 2438999 2438999 defendant Grubbe Richard yeoman 598873 598873 Grubbe, Richard, of Wythyham, yeoman 12
5340717 2457297 2457297 defendant Gilbard Roger husbandman 598873 598873 Gilbard, Roger, of Wythyham, husbandman 1
5389251 2471970 2471970 defendant Capon William tailor 598873 598873 Capon, William, of Wythyham, tailor 1
5401898 2475606 2475606 defendant Gaston William tailor 598873 598873 Gaston, William, of Wythyham, 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);