names

87 rows where place_id = 592330

✎ 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
3607370 1869966 1869966 defendant Baxter Thomas husbandman 592330 592330 Baxter, Thomas, of Stanhowe, husbandman 1
3616684 1872847 1872847 defendant Manser Robert husbandman 592330 592330 Manser, Robert, of Stanhowe, husbandman 3
3616692 1872850 1872850 defendant Manser Robert husbandman 592330 592330 Manser, Robert, of Stanhowe, husbandman 1
3868640 1979751 1979751 defendant Hoker Richard clerk 592330 592330 Hoker, Richard, of Stanhowe, clerk 0
3873884 1981483 1981483 defendant Howman Henry yeoman 592330 592330 Howman, Henry, of Stanhowe, yeoman 1
3885413 1985376 1985376 plaintiff Baxter Robert   592330 592330 Baxter, Robert, of Stanhowe 0
3889917 1986865 1986865 defendant Smyth Edward yeoman 592330 592330 Smyth, Edward, of Stanhowe, yeoman 1
3982178 2018388 2018388 defendant Baxter Thomas gent 592330 592330 Baxter, Thomas, of Stanhowe, gent 1
4013665 2029624 2029624 defendant Baxter Thomas gent 592330 592330 Baxter, Thomas, of Stanhowe, gent 0
4013667 2029625 2029625 defendant Baxter Thomas gent 592330 592330 Baxter, Thomas, of Stanhowe, gent 0
4015434 2030216 2030216 plaintiff Smyth William yeoman 592330 592330 Smyth, William, of Stanhowe, yeoman 0
4019155 2031588 2031588 defendant Smyth Henry yeoman 592330 592330 Smyth, Henry, of Stanhowe, yeoman 0
4021326 2032350 2032350 defendant Baxster William yeoman 592330 592330 Baxster, William, of Stanhowe, yeoman 5
4024483 2033432 2033432 defendant Smythe Henry yeoman 592330 592330 Smythe, Henry, of Stanhowe, yeoman 0
4024485 2033433 2033433 defendant Smythe Henry yeoman 592330 592330 Smythe, Henry, of Stanhowe, yeoman 0
4042876 2039928 2039928 defendant Smyth Henry yeoman 592330 592330 Smyth, Henry, of Stanhowe, yeoman 0
4044402 2040451 2040451 defendant Tayler John husbandman 592330 592330 Tayler John, of Stanhowe, husbandman 0
4044406 2040452 2040452 defendant Baxster William yeoman 592330 592330 Baxster, William, of Stanhowe, yeoman 2
4044411 2040453 2040453 defendant Baxster William yeoman 592330 592330 Baxster, William, of Stanhowe, yeoman 3
4045237 2040751 2040751 defendant Baxter Thomas gent 592330 592330 Baxter, Thomas, of Stanhowe, gent 1
4045238 2040751 2040751 defendant Taylour John husbandman 592330 592330 Taylour, John, of Stanhowe, husbandman 2
4056032 2044540 2044540 defendant Smyth Henry yeoman 592330 592330 Smyth, Henry, of Stanhowe, yeoman 0
4074453 2051166 2051166 defendant Smythe Henry gent 592330 592330 Smythe, Henry, of Stanhowe, gent 1
4076902 2052026 2052026 plaintiff Smyth John gent 592330 592330 Smyth, John, of Stanhowe, gent 0
4079977 2053142 2053142 plaintiff Veare Henry gent 592330 592330 Veare, Henry, of Stanhowe, gent 0
4079978 2053142 2053142 defendant Baxter William yeoman 592330 592330 Baxter, William, of Stanhowe, yeoman 0
4080298 2053261 2053261 defendant Smyth Henry yeoman 592330 592330 Smyth, Henry, of Stanhowe, yeoman 0
4108599 2063330 2063330 defendant Baxter Thomas gent 592330 592330 Baxter, Thomas, of Stanhowe, gent 0
4175224 2086797 2086797 defendant Baxter Thomas gent 592330 592330 Baxter, Thomas, of Stanhowe, gent 0
4387965 2160603 2160603 defendant Moll Hugh husbandman 592330 592330 Moll, Hugh, of Stanhowe, husbandman 0
4387966 2160603 2160603 defendant Symes or Symmes Simon husbandman 592330 592330 Symes or Symmes, Simon, of Stanhowe, husbandman 1
4387967 2160603 2160603 defendant Kempe Stephen husbandman 592330 592330 Kempe, Stephen, of Stanhowe, husbandman 2
4387968 2160603 2160603 defendant Rust William   592330 592330 Rust, William, of Stanhowe, shepherd 3
4390196 2161344 2161344 defendant Moll Hugh husbandman 592330 592330 Moll, Hugh, of Stanhowe, husbandman 0
4390197 2161344 2161344 defendant Symes or Symmes Simon husbandman 592330 592330 Symes or Symmes, Simon, of Stanhowe, husbandman 1
4390198 2161344 2161344 defendant Kempe Stephen husbandman 592330 592330 Kempe, Stephen, of Stanhowe, husbandman 2
4390199 2161344 2161344 defendant Rust William   592330 592330 Rust, William, of Stanhowe, shepherd 3
4424506 2172502 2172502 defendant Revand John   592330 592330 together with Revand, John, of Stanhowe, son of William 2
4427694 2173497 2173497 defendant Cok Henry   592330 592330 Cok, Henry, of Stanhowe 0
4427699 2173499 2173499 defendant Foxele Hugh   592330 592330 Foxele, Hugh, of Stanhowe, parson who vouched Gyn, Ralph, of Stanhowe, son & heir of Walter 1
4481951 2195062 2195062 plaintiff Marche Bartholomew   592330 592330 Marche, Bartholomew, of Stanhowe 0
4518039 2206017 2206017 defendant Tunnewelle Richard   592330 592330 Tunnewelle, Richard, of Stanhowe 4
4556004 2217820 2217820 defendant Sippe William   592330 592330 Sippe, William, of Stanhowe 0
4559265 2218851 2218851 plaintiff Tonewell Robert   592330 592330 Tonewell, Robert, of Stanhowe 1
4559268 2218852 2218852 plaintiff Tonewell Robert   592330 592330 Tonewell, Robert, of Stanhowe 1
4587682 2227552 2227552 defendant Hounmanus Paul   592330 592330 Hounmanus, Paul, of Stanhowe 0
4618042 2236652 2236652 defendant Paget John   592330 592330 Paget, John, of Stanhowe 3
4619641 2237129 2237129 plaintiff Homan Henry   592330 592330 Homan, Henry, of Stanhowe 0
4651481 2246466 2246466 defendant de Lincolne John weaver 592330 592330 de Lincolne, John, of Stanhowe, weaver 0
4653242 2246952 2246952 defendant Scot Roger husbandman 592330 592330 Scot, Roger, of Stanhowe, husbandman 0
4653243 2246952 2246952 defendant Mancere John husbandman 592330 592330 Mancere, John, of Stanhowe, husbandman 1
4653244 2246953 2246953 plaintiff Bay Roger   592330 592330 Bay, Roger, of Stanhowe 0
4653246 2246954 2246954 plaintiff Bay Roger   592330 592330 Bay, Roger, of Stanhowe 0
4653248 2246955 2246955 plaintiff Bay Roger   592330 592330 Bay, Roger, of Stanhowe 0
4653250 2246956 2246956 plaintiff Bay Roger   592330 592330 Bay, Roger, of Stanhowe 0
4661022 2249273 2249273 plaintiff Godfrey John   592330 592330 Godfrey, John, of Stanhowe 2
4661023 2249273 2249273 defendant Paget John   592330 592330 Paget, John, of Stanhowe, shepherd 0
4827463 2304639 2304639 defendant Bassage Robert clerk 592330 592330 Bassage, Robert, of Stanhowe, clerk 0
4832951 2306325 2306325 plaintiff Chapman Henry (legal representative) 592330 592330 Chapman, Henry, of Stanhowe, executrix of 0
4862874 2315373 2315373 defendant Tunwell Robert yeoman 592330 592330 Tunwell, Robert, of Stanhowe, yeoman 0
4889713 2323577 2323577 defendant Baxster Thomas yeoman 592330 592330 Baxster, Thomas, of Stanhowe, yeoman 0
4933782 2336944 2336944 defendant Goodale William husbandman 592330 592330 Goodale, William, of Stanhowe, husbandman 2
5053649 2372695 2372695 plaintiff Baxter Thomas   592330 592330 Baxter, Thomas, of Stanhowe 0
5125527 2393953 2393953 plaintiff Bernesdale John   592330 592330 (Bernesdale, John, of Stanhowe, son of Testator 1
5144160 2399445 2399445 plaintiff Bernesdale John   592330 592330 (Bernesdale, John, of Stanhowe, son of John Bernesdale, of Berewyk 1
5144166 2399446 2399446 plaintiff Bernesdale John   592330 592330 (Bernesdale, John, of Stanhowe, son of John Bernesdale, of Berwyk 1
5179344 2409698 2409698 plaintiff Bernesdale John   592330 592330 (Bernesdale, John, of Stanhowe, son of John Bernesdale 1
5201253 2416121 2416121 defendant Baxster Thomas yeoman 592330 592330 Baxster, Thomas, of Stanhowe, yeoman 1
5201856 2416310 2416310 plaintiff Bernesdale John   592330 592330 (Bernesdale, John, of Stanhowe, son of John Bernesdale 1
5211949 2419233 2419233 defendant Baxster Thomas yeoman 592330 592330 Baxster, Thomas, of Stanhowe, yeoman 1
5213042 2419552 2419552 plaintiff Bernesdale John   592330 592330 (Bernesdale, John, of Stanhowe, his son 1
5213048 2419553 2419553 plaintiff Bernesdale John   592330 592330 (Bernesdale, John, of Stanhowe, his son 1
5231095 2424692 2424692 plaintiff Baxstere Thomas   592330 592330 Baxstere, Thomas, of Stanhowe 1
5283035 2440099 2440099 defendant Anger or Auger Roger husbandman 592330 592330 Anger or Auger, Roger, of Stanhowe, husbandman 3
5286703 2441120 2441120 defendant Goodale William husbandman 592330 592330 Goodale, William, of Stanhowe, husbandman 5
5286710 2441121 2441121 defendant Goodale William husbandman 592330 592330 Goodale, William, of Stanhowe, husbandman 4
5290765 2442300 2442300 defendant Angell Roger husbandman 592330 592330 Angell, Roger, of Stanhowe, husbandman 4
5344767 2458531 2458531 defendant Clerk Thomas yeoman 592330 592330 Clerk, Thomas, of Stanhowe, yeoman 1
5415167 2479477 2479477 defendant Mersh Robert husbandman 592330 592330 Mersh, Robert, of Stanhowe, husbandman 1
5427135 2483054 2483054 defendant Downyng John husbandman 592330 592330 Downyng, John, of Stanhowe, husbandman 1
5485062 2500451 2500451 plaintiff Palet Thomas (legal representative) 592330 592330 Palet, Thomas, of Stanhowe, chaplain, executors of 0
5496023 2503703 2503703 defendant Carter Simon   592330 592330 Carter, Simon, of Stanhowe, shepherd 4
5512499 2508770 2508770 defendant Godale Robert husbandman 592330 592330 Godale, Robert, of Stanhowe, husbandman 0
5530688 2514117 2514117 defendant Radclyff William clerk 592330 592330 Radclyff, William, of Stanhowe, clerk 2
5532893 2514829 2514829 defendant Manser Robert husbandman 592330 592330 Manser, Robert, of Stanhowe, husbandman 2
5618042 2549460 2549460 defendant Marche Bartholomew   592330 592330 Marche, Bartholomew, of Stanhowe, son of John 0
5629708 2553284 2553284 defendant Huchon John husbandman 592330 592330 Huchon, John, of Stanhowe, husbandman 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);