names

74 rows where place_id = 586156

✎ 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
3588047 1863914 1863914 defendant Garell William husbandman 586156 586156 Garell, William, of Magna Cressyngham, husbandman 0
3594869 1866025 1866025 defendant Rysley Richard gent 586156 586156 Rysley, Richard, of Magna Cressyngham, gent 0
3598131 1867043 1867043 defendant Wase or Wafe Richard husbandman 586156 586156 Wase or Wafe, Richard, of Magna Cressyngham, husbandman 0
3606085 1869570 1869570 defendant Crosse John husbandman 586156 586156 Crosse, John, of Magna Cressyngham, husbandman 2
3606086 1869570 1869570 defendant Stede Henry   586156 586156 Stede, Henry, of Magna Cressyngham, shepherd 3
3616829 1872892 1872892 defendant Chandeler Richard husbandman 586156 586156 Chandeler, Richard, of Magna Cressyngham, husbandman 0
3621479 1874257 1874257 defendant Crosse Thomas husbandman 586156 586156 Crosse, Thomas, of Magna Cressyngham, husbandman 1
3621480 1874257 1874257 defendant Grey John laborer 586156 586156 Grey, John, of Magna Cressyngham, laborer 2
3626806 1903233 1903233 defendant Steyney William husbandman 586156 586156 Steyney, William, of Magna Cressyngham, husbandman 0
3644047 1908568 1908568 defendant Styony William husbandman 586156 586156 Styony, William, of Magna Cressyngham, husbandman 0
3701324 1926658 1926658 defendant Hawyn John   586156 586156 Hawyn, John, of Magna Cressyngham, shepherd 0
3701326 1926659 1926659 defendant Hawyn John   586156 586156 Hawyn, John, of Magna Cressyngham, shepherd 0
3702888 1927175 1927175 defendant Styenye William husbandman 586156 586156 Styenye, William, of Magna Cressyngham, husbandman 0
3702903 1927180 1927180 defendant Butler William husbandman 586156 586156 Butler, William, of Magna Cressyngham, husbandman 0
3702906 1927181 1927181 defendant Steynye William husbandman 586156 586156 Steynye, William, of Magna Cressyngham, husbandman 1
3702907 1927181 1927181 defendant Butteler William husbandman 586156 586156 Butteler, William, of Magna Cressyngham, husbandman 2
3734039 1936894 1936894 defendant Boteler William husbandman 586156 586156 Boteler, William, of Magna Cressyngham, husbandman 1
3799258 1957681 1957681 defendant Grey Robert miller 586156 586156 Grey, Robert, of Magna Cressyngham, miller 0
3802497 1958678 1958678 defendant Holles John   586156 586156 Holles, John, of Magna Cressyngham, shepherd 1
3818681 1963746 1963746 defendant Beamond Richard husbandman 586156 586156 Beamond, Richard, of Magna Cressyngham, husbandman 2
3818686 1963747 1963747 defendant Garell Robert laborer 586156 586156 Garell, Robert, of Magna Cressyngham, laborer 3
3818687 1963747 1963747 defendant Feltwell Andrew laborer 586156 586156 Feltwell, Andrew, of Magna Cressyngham, laborer 4
3842620 1971220 1971220 defendant Gaunte William husbandman 586156 586156 Gaunte, William, of Magna Cressyngham, husbandman 0
3908767 1993227 1993227 defendant Purveys Thomas blacksmith 586156 586156 Purveys, Thomas, of Magna Cressyngham, blacksmith 2
3914474 1995182 1995182 defendant Purvys Thomas smith 586156 586156 Purvys, Thomas, of Magna Cressyngham, smith 0
3914475 1995182 1995182 defendant Gaunt William husbandman 586156 586156 Gaunt, William, of Magna Cressyngham, husbandman 1
3916491 1995893 1995893 defendant Freman Christopher husbandman 586156 586156 Freman, Christopher, of Magna Cressyngham, husbandman 0
3916492 1995893 1995893 defendant Barbour John husbandman 586156 586156 Barbour, John, of Magna Cressyngham, husbandman 1
3924884 1998640 1998640 defendant Hougton Robert gent 586156 586156 Hougton, Robert, of Magna Cressyngham, gent 1
3971324 2014528 2014528 defendant Syllett Simon husbandman 586156 586156 Syllett, Simon, of Magna Cressyngham, husbandman 0
3980335 2017737 2017737 defendant Syllet Simon husbandman 586156 586156 Syllet, Simon, of Magna Cressyngham, husbandman 1
4037173 2037956 2037956 defendant Wace Richard husbandman 586156 586156 Wace, Richard, of Magna Cressyngham, husbandman 0
4037174 2037956 2037956 defendant Wace William (legal representative) 586156 586156 Wace, William, of Magna Cressyngham, butcher, administrator of 1
4037175 2037956 2037956 defendant Wace Richard, junior husbandman 586156 586156 Wace, Richard, junior, of Magna Cressyngham, husbandman 2
4037176 2037956 2037956 defendant Graunte Lionel   586156 586156 Graunte, Lionel, of Magna Cressyngham, husbandman, administrators of 3
4072248 2050375 2050375 defendant Gashion John husbandman 586156 586156 Gashion, John, of Magna Cressyngham, husbandman 1
4255141 2114710 2114710 defendant Wace Richard yeoman 586156 586156 Wace, Richard, of Magna Cressyngham, yeoman 2
4255142 2114710 2114710 defendant Chadwyck alias Smyth Brimsted husbandman 586156 586156 Chadwyck alias Smyth, Brimsted, of Magna Cressyngham, husbandman 3
4888076 2323074 2323074 defendant Rysley John gent 586156 586156 Rysley, John, of Magna Cressyngham, gent 0
4895358 2325208 2325208 plaintiff Costard Richard   586156 586156 Costard, Richard, of Magna Cressyngham 1
4897801 2325977 2325977 plaintiff Rysle John   586156 586156 Rysle, John, of Magna Cressyngham 0
4897830 2325985 2325985 defendant atte Went Richard yeoman 586156 586156 atte Went, Richard, of Magna Cressyngham, yeoman 0
4897831 2325985 2325985 defendant Dale John husbandman 586156 586156 Dale, John, of Magna Cressyngham, husbandman 1
4900136 2326669 2326669 defendant Freman Edmund yeoman 586156 586156 Freman, Edmund, of Magna Cressyngham, yeoman 1
4905047 2328187 2328187 defendant Rysley John gent 586156 586156 Rysley, John, of Magna Cressyngham, gent 0
4939459 2338724 2338724 plaintiff Costard Richard   586156 586156 Costard, Richard, of Magna Cressyngham 0
4949887 2341942 2341942 defendant Ryslee Margery widow 586156 586156 Ryslee, Margery, of Magna Cressyngham, widow 0
4954972 2343445 2343445 defendant Rysle John (legal representative) 586156 586156 Rysle, John, of Magna Cressyngham, executors of 4
4968662 2347596 2347596 defendant Costard Richard husbandman 586156 586156 Costard, Richard, of Magna Cressyngham, husbandman 0
4971801 2348492 2348492 defendant Costard Richard yeoman 586156 586156 Costard, Richard, of Magna Cressyngham, yeoman 0
4971804 2348493 2348493 defendant Wygenhale Robert yeoman 586156 586156 Wygenhale, Robert, of Magna Cressyngham, yeoman 0
5014286 2361031 2361031 defendant Kyppyng John husbandman 586156 586156 Kyppyng, John, of Magna Cressyngham, husbandman 1
5024034 2363939 2363939 defendant Bryston alias Nicolasson William husbandman 586156 586156 Bryston alias Nicolasson, William, of Magna Cressyngham, husbandman 1
5033679 2366730 2366730 defendant Wygenhale Robert yeoman 586156 586156 Wygenhale, Robert, of Magna Cressyngham, yeoman 1
5036552 2367553 2367553 defendant Wasse or Wace Thomas yeoman 586156 586156 Wasse or Wace, Thomas, of Magna Cressyngham, yeoman 0
5075999 2379314 2379314 defendant Bardolf Edmund gent 586156 586156 Bardolf, Edmund, of Magna Cressyngham, gent 0
5076002 2379315 2379315 defendant Bardolf Edmund gent 586156 586156 Bardolf, Edmund, of Magna Cressyngham, gent 0
5088640 2383052 2383052 defendant Wethir John husbandman 586156 586156 Wethir, John, of Magna Cressyngham,husbandman 0
5089569 2383325 2383325 defendant Buk John husbandman 586156 586156 Buk, John, of Magna Cressyngham, husbandman 0
5228159 2423844 2423844 defendant Fowecher William husbandman 586156 586156 Fowecher, William, of Magna Cressyngham, husbandman 1
5259139 2432974 2432974 defendant Fynche Richard husbandman 586156 586156 Fynche, Richard, of Magna Cressyngham, husbandman 0
5347843 2459474 2459474 defendant Rysley Richard gent 586156 586156 Rysley, Richard, of Magna Cressyngham, gent 3
5500420 2505069 2505069 defendant Wace John butcher 586156 586156 Wace, John, of Magna Cressyngham, butcher 1
5504117 2506205 2506205 defendant Wace Richard yeoman 586156 586156 Wace, Richard, of Magna Cressyngham, yeoman 0
5527822 2513270 2513270 defendant Garell William husbandman 586156 586156 Garell, William, of Magna Cressyngham, husbandman 2
5533871 2515138 2515138 defendant Lakford John husbandman 586156 586156 Lakford, John, of Magna Cressyngham, husbandman 2
5533872 2515138 2515138 defendant Garell John husbandman 586156 586156 Garell, John, of Magna Cressyngham, husbandman 3
5533873 2515138 2515138 defendant Pawe Robert husbandman 586156 586156 Pawe, Robert, of Magna Cressyngham, husbandman 4
5534715 2515400 2515400 defendant Gerard John husbandman 586156 586156 Gerard, John, of Magna Cressyngham, husbandman 0
5534716 2515400 2515400 defendant Shyllyng John husbandman 586156 586156 Shyllyng, John, of Magna Cressyngham, husbandman 1
5534717 2515400 2515400 defendant Mannyng John laborer 586156 586156 Mannyng, John, of Magna Cressyngham, laborer 2
5578740 2528414 2528414 defendant Steyenye William husbandman 586156 586156 Steyenye, William, of Magna Cressyngham, husbandman 0
5583613 2529951 2529951 defendant Constabyll Richard miller 586156 586156 Constabyll, Richard, of Magna Cressyngham, miller 0
5596015 2533664 2533664 defendant Wylson Thomas tailor 586156 586156 Wylson, Thomas, of Magna Cressyngham, 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);