names

56 rows where place_id = 588586

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594995 1866064 1866064 defendant Burdon Robert mercer 588586 588586 Burdon, Robert, of Rothwell, mercer 0
3594996 1866064 1866064 defendant Tympkoke Robert butcher 588586 588586 Tympkoke, Robert, of Rothwell, butcher 1
3699398 1926033 1926033 defendant Brighton William weaver 588586 588586 Brighton, William, of Rothwell, weaver 0
3747029 1940988 1940988 defendant Lucas Robert tanner 588586 588586 Lucas, Robert, of Rothwell, tanner 1
3747032 1940988 1940988 defendant Moxson Robert husbandman 588586 588586 Moxson, Robert, of Rothwell, husbandman 4
3747417 1941106 1941106 defendant Lucas Robert tanner 588586 588586 Lucas, Robert, of Rothwell, tanner 0
3800197 1957982 1957982 defendant Gascoigne Humphrey clerk 588586 588586 Gascoigne, Humphrey, of Rothwell, clerk 0
3800198 1957982 1957982 defendant Crofte William yeoman 588586 588586 Crofte, William, of Rothwell, yeoman 1
3881347 1984026 1984026 defendant Crofte Thomas   588586 588586 Crofte, Thomas, of Rothwell, cook 0
3971464 2014579 2014579 defendant Leighe Richard gent 588586 588586 Leighe, Richard, of Rothwell, gent 0
3971466 2014580 2014580 defendant Wilbore Nicholas gent 588586 588586 Wilbore, Nicholas, of Rothwell, gent 0
3995574 2023161 2023161 defendant Lucas William tanner 588586 588586 Lucas, William, of Rothwell, tanner 0
3995578 2023163 2023163 defendant Westerman William yeoman 588586 588586 Westerman, William, of Rothwell, yeoman 0
4060237 2046063 2046063 defendant Grene Thomas yeoman 588586 588586 Grene, Thomas, of Rothwell, yeoman 1
4060245 2046064 2046064 defendant Grene Thomas yeoman 588586 588586 Grene, Thomas, of Rothwell, yeoman 1
4085685 2055150 2055150 defendant Dobson Anne widow 588586 588586 Anne his wife, formerly Anne Brokehouse, of Rothwell, widow 1
4087048 2055661 2055661 defendant Coke Robert laborer 588586 588586 Coke, Robert, of Rothwell, laborer 0
4123488 2068703 2068703 defendant Fether James husbandman 588586 588586 Fether, James, of Rothwell, husbandman 2
4134228 2072565 2072565 defendant Brokelsbey Henry laborer 588586 588586 Brokelsbey, Henry, of Rothwell, laborer 2
4135370 2072970 2072970 defendant Harrison Mathew butcher 588586 588586 Harrison, Mathew, of Rothwell, butcher 0
4146632 2076973 2076973 defendant Wood Anthony yeoman 588586 588586 Wood, Anthony, of Rothwell, yeoman 3
4176136 2087128 2087128 defendant Grene John husbandman 588586 588586 Grene, John, of Rothwell, husbandman 2
4176137 2087128 2087128 defendant Brockelsbye Thomas husbandman 588586 588586 Brockelsbye, Thomas, of Rothwell, husbandman 3
4185979 2090586 2090586 defendant Grene John, junior yeoman 588586 588586 Grene, John, junior, of Rothwell, yeoman 0
4185980 2090586 2090586 defendant Brokelsbye Thomas yeoman 588586 588586 Brokelsbye, Thomas, of Rothwell, yeoman 1
4187726 2091209 2091209 defendant Brokelsbye Henry yeoman 588586 588586 Brokelsbye, Henry, of Rothwell, yeoman 0
4187727 2091209 2091209 defendant Brokelsbye Thomas yeoman 588586 588586 Brokelsbye, Thomas, of Rothwell, yeoman 1
4198628 2095078 2095078 defendant Brockelsbye Henry husbandman 588586 588586 Brockelsbye, Henry, of Rothwell, husbandman 2
4231829 2106630 2106630 defendant Hargraves William yeoman 588586 588586 Hargraves, William, of Rothwell, yeoman 0
4232598 2106905 2106905 defendant Hall Edward husbandman 588586 588586 Hall, Edward, of Rothwell, husbandman 0
4236237 2108244 2108244 defendant Brockelsbie Thomas carpenter 588586 588586 Brockelsbie, Thomas, of Rothwell, carpenter 0
4236238 2108244 2108244 defendant Brockelsbie Henry laborer 588586 588586 Brockelsbie, Henry, of Rothwell, laborer 1
4239520 2109447 2109447 defendant Brockelsbie Thomas   588586 588586 Brockelsbie, Thomas, of Rothwell, husbandman, bachelor 1
4239549 2109459 2109459 defendant Brocklesbie Jane widow 588586 588586 Brocklesbie, Jane, of Rothwell, widow 2
4247718 2112217 2112217 defendant Brockelsbie Thomas   588586 588586 Brockelsbie, Thomas, of Rothwell, husbandman, bachelor 1
4247836 2112261 2112261 defendant Brockelsbie Thomas   588586 588586 Brockelsbie, Thomas, of Rothwell, husbandman, bachelor 1
4247885 2112275 2112275 defendant Brockelsbie Jane widow 588586 588586 Brockelsbie, Jane, of Rothwell, widow 2
4293523 2127747 2127747 defendant Greene John husbandman 588586 588586 Greene, John, of Rothwell, husbandman 0
4293524 2127747 2127747 defendant Greene Thomas husbandman 588586 588586 Greene, Thomas, of Rothwell, husbandman 1
4300842 2130399 2130399 defendant Brigg alias Westerne Thomas husbandman 588586 588586 Brigg alias Westerne, Thomas, of Rothwell, husbandman 1
4309636 2133529 2133529 defendant Hargreves William, junior husbandman 588586 588586 Hargreves, William, junior, of Rothwell, husbandman 1
4317005 2136060 2136060 defendant Grene John, junior husbandman 588586 588586 Grene, John, junior, of Rothwell, husbandman 0
4333938 2141635 2141635 defendant Walter John husbandman 588586 588586 Walter, John, of Rothwell, husbandman 0
4350698 2147497 2147497 defendant Blenckinsop William yeoman 588586 588586 Blenckinsop, William, of Rothwell, yeoman 0
4360169 2150800 2150800 defendant Brockelsbye Henry laborer 588586 588586 Brockelsbye, Henry, of Rothwell, laborer 2
4362824 2151764 2151764 defendant Carter John blacksmith 588586 588586 Carter, John, of Rothwell, blacksmith 0
4367061 2153274 2153274 defendant Whelpdale John husbandman 588586 588586 Whelpdale, John, of Rothwell, husbandman 2
4367062 2153274 2153274 defendant Grene Richard laborer 588586 588586 Grene, Richard, of Rothwell, laborer 3
4372973 2155403 2155403 defendant Savill John yeoman 588586 588586 Savill, John, of Rothwell, yeoman 0
4384851 2159622 2159622 defendant Hargrave William, junior chapman 588586 588586 Hargrave, William, junior, of Rothwell, chapman 1
4387439 2160444 2160444 defendant Burnell Michael laborer 588586 588586 Burnell, Michael, of Rothwell, laborer 1
4507641 2202851 2202851 defendant Germethorp John de   588586 588586 Germethorp, John de, of Rothwell, parson 2
4558283 2218533 2218533 defendant Hostilere John   588586 588586 Hostilere, John, of Rothwell 0
5565315 2524443 2524443 defendant Moxon Robert yeoman 588586 588586 Moxon, Robert, of Rothwell, yeoman 1
5572033 2526368 2526368 defendant Lucas Stephan tanner 588586 588586 Lucas, Stephan, of Rothwell, tanner 0
5586897 2530936 2530936 defendant Croft William mercer 588586 588586 Croft, William, of Rothwell, mercer 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);