names

60 rows where place_id = 586168

✎ 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
3588071 1863918 1863918 defendant Cage Thomas husbandman 586168 586168 Cage, Thomas, of Skernyng, husbandman 2
3606980 1869846 1869846 plaintiff Pounfrette John, senior   586168 586168 Pounfrette, John, senior, of Skernyng, senior 1
3635179 1905799 1905799 defendant Hochechyns George clerk 586168 586168 Hochechyns, George, of Skernyng, clerk 0
3655586 1912009 1912009 defendant Barton Philip tailor 586168 586168 Barton, Philip, of Skernyng, tailor 2
3660627 1913586 1913586 defendant Wright John clerk 586168 586168 Wright, John, of Skernyng, clerk 0
3681399 1920269 1920269 defendant Wryght John clerk 586168 586168 Wryght, John, of Skernyng, clerk 0
3720238 1932607 1932607 plaintiff Hoo Richard gent 586168 586168 Hoo, Richard, of Skernyng, gent 0
3761359 1945563 1945563 defendant Hoo Richard gent 586168 586168 Hoo, Richard, of Skernyng, gent 1
3786019 1953419 1953419 defendant Aunger William husbandman 586168 586168 Aunger, William, of Skernyng, husbandman 3
3802314 1958622 1958622 defendant Aunger William husbandman 586168 586168 Aunger, William, of Skernyng, husbandman 3
3802319 1958623 1958623 defendant Aunger William husbandman 586168 586168 Aunger, William, of Skernyng, husbandman 3
3863156 1977880 1977880 defendant Wayte Richard   586168 586168 Wayte, Richard, of Skernyng, worsted weaver 0
3878155 1982941 1982941 defendant Haryngton Richard husbandman 586168 586168 Haryngton, Richard, of Skernyng, husbandman 7
3928027 1999709 1999709 defendant Grene Edmund gent 586168 586168 Grene, Edmund, of Skernyng, gent 0
3929148 2000089 2000089 defendant Skyman William yeoman 586168 586168 Skyman, William, of Skernyng, yeoman 0
4018060 2031178 2031178 defendant Banes John tanner 586168 586168 Banes, John, of Skernyng, tanner 0
4325198 2138807 2138807 defendant Busden Thomas husbandman 586168 586168 Busden, Thomas, of Skernyng, husbandman 0
4449076 2184654 2184654 defendant Camplyon John   586168 586168 Camplyon, John, of Skernyng 1
4464187 2189469 2189469 defendant Rounyng Richard   586168 586168 Rounyng, Richard, of Skernyng 1
4565762 2220847 2220847 defendant Basse John   586168 586168 Basse, John, of Skernyng 0
4607382 2233418 2233418 defendant Gegge John   586168 586168 Gegge, John, of Skernyng 1
4614358 2235500 2235500 defendant Smyth John   586168 586168 Smyth, John, of Skernyng 3
4674305 2257572 2257572 defendant Smyth John yeoman 586168 586168 Smyth, John, of Skernyng, yeoman 0
4691887 2262997 2262997 defendant Agge Thomas fuller 586168 586168 Agge, Thomas, of Skernyng, fuller 1
4756785 2282487 2282487 defendant Pope John laborer 586168 586168 Pope, John, of Skernyng, laborer 0
4791888 2293565 2293565 plaintiff Martyn Adam   586168 586168 Martyn, Adam, of Skernyng 0
4937044 2337962 2337962 defendant Rodelond John skinner 586168 586168 Rodelond, John, of Skernyng, skinner 2
4955024 2343456 2343456 defendant Peyntour Katherine widow 586168 586168 Peyntour, Katherine, of Skernyng, widow 0
4962472 2345679 2345679 defendant Rodelond John skinner 586168 586168 Rodelond, John, of Skernyng, skinner 2
5013141 2360671 2360671 defendant Tulley Robert husbandman 586168 586168 Tulley, Robert, of Skernyng, husbandman 0
5020986 2363037 2363037 defendant Manne Robert husbandman 586168 586168 Manne, Robert, of Skernyng, husbandman 0
5029954 2365633 2365633 defendant Broun Isabel widow 586168 586168 Broun, Isabel, of Skernyng, widow 0
5074047 2378727 2378727 defendant Rowenyng William laborer 586168 586168 Rowenyng, William, of Skernyng, laborer 0
5077950 2379887 2379887 defendant Sekker William husbandman 586168 586168 Sekker, William, of Skernyng, husbandman 0
5090254 2383521 2383521 defendant Fyssher James husbandman 586168 586168 Fyssher, James, of Skernyng, husbandman 1
5090260 2383523 2383523 defendant Waryn Thomas husbandman 586168 586168 Waryn, Thomas, of Skernyng, husbandman 0
5090261 2383523 2383523 defendant Stalon alias Brygge John husbandman 586168 586168 Stalon alias Brygge, John, of Skernyng, husbandman 1
5115857 2391065 2391065 plaintiff Neweman Thomas   586168 586168 Neweman, Thomas, of Skernyng 0
5124269 2393545 2393545 defendant Ruddelond John skinner 586168 586168 Ruddelond, John, of Skernyng, skinner 2
5125847 2394045 2394045 defendant Stalen John thatcher 586168 586168 Stalen, John, of Skernyng, thatcher 0
5132745 2396072 2396072 defendant Colyn John yeoman 586168 586168 Colyn, John, of Skernyng, yeoman 0
5191042 2413123 2413123 defendant Pomfrey John husbandman 586168 586168 Pomfrey, John, of Skernyng, husbandman 2
5196649 2414774 2414774 defendant Pomfret John husbandman 586168 586168 Pomfret, John, of Skernyng, husbandman 1
5207204 2417847 2417847 defendant Pounfreyt John husbandman 586168 586168 Pounfreyt, John, of Skernyng, husbandman 2
5209771 2418594 2418594 defendant Pomfred John husbandman 586168 586168 Pomfred, John, of Skernyng, husbandman 1
5219646 2421480 2421480 defendant Colyn John husbandman 586168 586168 Colyn, John, of Skernyng, husbandman 3
5219651 2421481 2421481 defendant Colyn John husbandman 586168 586168 Colyn, John, of Skernyng, husbandman 2
5224520 2422840 2422840 defendant Neweman Thomas yeoman 586168 586168 Neweman, Thomas, of Skernyng, yeoman 0
5231503 2424798 2424798 defendant Pomfreyt John yeoman 586168 586168 Pomfreyt, John, of Skernyng, yeoman 3
5231504 2424798 2424798 defendant Belde Thomas husbandman 586168 586168 Belde, Thomas, of Skernyng, husbandman 4
5256545 2432165 2432165 defendant Pounfreyt John yeoman 586168 586168 Pounfreyt, John, of Skernyng, yeoman 3
5264944 2434793 2434793 defendant Pomfreyt Katherine widow 586168 586168 Pomfreyt, Katherine, of Skernyng, widow 8
5296573 2443986 2443986 defendant Palmer Robert yeoman 586168 586168 Palmer, Robert, of Skernyng, yeoman 0
5410007 2477960 2477960 defendant Choket William husbandman 586168 586168 Choket, William, of Skernyng, husbandman 9
5455661 2491595 2491595 defendant Choket William husbandman 586168 586168 Choket, William, of Skernyng, husbandman 7
5474399 2497324 2497324 defendant Wylly William tanner 586168 586168 Wylly, William, of Skernyng, tanner 0
5496819 2503974 2503974 defendant Tuddenham Edmund laborer 586168 586168 Tuddenham, Edmund, of Skernyng, laborer 0
5544578 2518414 2518414 defendant Pynnes John yeoman 586168 586168 Pynnes, John, of Skernyng, yeoman 0
5581256 2529208 2529208 defendant Gronde John thatcher 586168 586168 Gronde, John, of Skernyng, thatcher 2
5594667 2533308 2533308 defendant Kyrby Robert, senior husbandman 586168 586168 Kyrby, Robert, senior, of Skernyng, husbandman 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);