names

41 rows where place_id = 599120

✎ 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
3635392 1905867 1905867 defendant Cole William husbandman 599120 599120 Cole, William, of Poynton, husbandman 0
4104836 2062005 2062005 defendant Bradley William yeoman 599120 599120 Bradley, William, of Poynton, yeoman 1
4104837 2062005 2062005 defendant Bradley Lawrence   599120 599120 Bradley, Lawrence, of Poynton, husbandman, his son 2
4233921 2107395 2107395 defendant Jones Thomas gent 599120 599120 Jones, Thomas, of Poynton, gent 0
4274865 2121156 2121156 defendant Bayly Anthony yeoman 599120 599120 Bayly, Anthony, of Poynton, yeoman 0
4275333 2121306 2121306 defendant Balye Anthony gent 599120 599120 Balye, Anthony, of Poynton, gent 0
4275674 2121437 2121437 defendant Bullor Robert husbandman 599120 599120 Bullor, Robert, of Poynton, husbandman 0
4275676 2121438 2121438 defendant Rogerson Thomas husbandman 599120 599120 Rogerson, Thomas, of Poynton, husbandman 0
4352728 2148184 2148184 defendant Warren Richard gent 599120 599120 Warren, Richard, of Poynton, gent 2
4442396 2182563 2182563 plaintiff Brunne John de   599120 599120 Brunne, John de, of Poynton 0
4480822 2194668 2194668 defendant Boston John   599120 599120 Boston, John, of Poynton 0
4512289 2204282 2204282 defendant White William   599120 599120 White, William, of Poynton 0
4515725 2205345 2205345 defendant Bishop John   599120 599120 Bishop, John, of Poynton 0
4606166 2233039 2233039 defendant Bysshop John   599120 599120 Bysshop, John, of Poynton 0
4606167 2233039 2233039 defendant Aleynson John   599120 599120 Aleynson, John, of Poynton 1
4636148 2242137 2242137 defendant Bysshop John   599120 599120 Bysshop, John, of Poynton 0
4636149 2242137 2242137 defendant Aleynson John   599120 599120 Aleynson, John, of Poynton 1
4657140 2248122 2248122 defendant Bisshop John   599120 599120 Bisshop, John, of Poynton 5
4672114 2256925 2256925 defendant Bysshop John   599120 599120 Bysshop, John, of Poynton, bailiff 2
4682545 2260162 2260162 defendant Bisshop John   599120 599120 Bisshop, John, of Poynton, bailiff 3
4697106 2264572 2264572 plaintiff Claymond Richard   599120 599120 Claymond, Richard, of Poynton 0
4697108 2264573 2264573 plaintiff Claymond Richard   599120 599120 Claymond, Richard, of Poynton 0
4697110 2264574 2264574 plaintiff Claymond Richard   599120 599120 Claymond, Richard, of Poynton 0
4706934 2267547 2267547 defendant Bysshope John yeoman 599120 599120 Bysshope, John, of Poynton, yeoman 4
4706960 2267557 2267557 defendant Mannyng William husbandman 599120 599120 Mannyng, William, of Poynton, husbandman 0
4706961 2267557 2267557 defendant Claymond Richard husbandman 599120 599120 Claymond, Richard, of Poynton, husbandman 1
4716894 2270613 2270613 defendant Bisshop John husbandman 599120 599120 Bisshop, John, of Poynton, husbandman 0
4730588 2274766 2274766 defendant Claymond Richard yeoman 599120 599120 Claymond, Richard, of Poynton, yeoman 0
4750095 2280500 2280500 defendant Wyot John husbandman 599120 599120 Wyot, John, of Poynton, husbandman 0
4759559 2283330 2283330 defendant Sleghter William laborer 599120 599120 Sleghter, William, of Poynton, laborer 0
4772667 2287422 2287422 defendant Stevenson William husbandman 599120 599120 Stevenson, William, of Poynton, husbandman 0
4772668 2287422 2287422 defendant Moye Robert husbandman 599120 599120 Moye, Robert, of Poynton, husbandman 1
4776393 2288609 2288609 defendant Michell Robert husbandman 599120 599120 Michell, Robert, of Poynton, husbandman 0
4784314 2291092 2291092 defendant Oxton John shoemaker 599120 599120 Oxton, John, of Poynton, shoemaker 0
4798003 2295560 2295560 defendant Stevenson William husbandman 599120 599120 Stevenson, William, of Poynton, husbandman 0
4798004 2295560 2295560 defendant Dunnesby Robert tailor 599120 599120 Dunnesby, Robert, of Poynton, tailor 1
4979265 2350756 2350756 defendant Dunnesby Robert husbandman 599120 599120 Dunnesby, Robert, of Poynton, husbandman 0
4979266 2350756 2350756 defendant Rogerson Alan husbandman 599120 599120 Rogerson, Alan, of Poynton, husbandman 1
4979268 2350757 2350757 defendant Rogerson Alan husbandman 599120 599120 Rogerson, Alan, of Poynton, husbandman 0
5005086 2358387 2358387 defendant Dunnesby Robert tailor 599120 599120 Dunnesby, Robert, of Poynton, tailor 2
5611949 2547471 2547471 plaintiff Broune John   599120 599120 Broune, John, of Poynton 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);