names

45 rows where place_id = 593232

✎ 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
3610996 1871117 1871117 defendant Newenam John husbandman 593232 593232 Newenam, John, of Berkewey, husbandman 1
3711239 1929818 1929818 defendant Newenham John husbandman 593232 593232 Newenham, John, of Berkewey, husbandman 5
3773994 1949579 1949579 defendant Sterne John, senior innholder 593232 593232 Sterne, John, senior, of Berkewey, innholder 1
4503595 2201701 2201701 plaintiff Perys William   593232 593232 Perys, William, of Berkewey, vicar 2
4557655 2218328 2218328 defendant Salaman Thomas   593232 593232 Salaman, Thomas, of Berkewey 0
4579906 2225203 2225203 defendant Baker John   593232 593232 Baker, John, of Berkewey 3
4668298 2255799 2255799 defendant Royston Peter husbandman 593232 593232 Royston, Peter, of Berkewey, husbandman 0
4672593 2257071 2257071 defendant Reve William husbandman 593232 593232 Reve, William, of Berkewey, husbandman 0
4734640 2275992 2275992 defendant Reve Wiliam ostler 593232 593232 Reve, Wiliam, of Berkewey, ostler 8
4751794 2281015 2281015 defendant Reve William hostiler 593232 593232 Reve, William, of Berkewey, hostiler 1
4751795 2281015 2281015 defendant Andrewe Thomas fisher 593232 593232 Andrewe, Thomas, of Berkewey, fisher 2
4772563 2287387 2287387 defendant Reve William hosteller 593232 593232 Reve, William, of Berkewey, hosteller 1
4772564 2287387 2287387 defendant Andrewe Thomas fishmonger 593232 593232 Andrewe, Thomas, of Berkewey, fishmonger 2
4799836 2296130 2296130 defendant Reve William hosteler 593232 593232 Reve, William, of Berkewey, hosteler 0
4809879 2299252 2299252 defendant Grene Thomas husbandman 593232 593232 Grene, Thomas, of Berkewey, husbandman 0
4813016 2300187 2300187 defendant Hawe John yeoman 593232 593232 Hawe, John, of Berkewey, yeoman 1
4815388 2300919 2300919 defendant Bakere John smith 593232 593232 Bakere, John, of Berkewey, smith 0
4832376 2306160 2306160 defendant Bateman John hosteller 593232 593232 Bateman, John, of Berkewey, hosteller 0
4843363 2309438 2309438 defendant Reve or Rene William (legal representative) 593232 593232 Reve or Rene, William, of Berkewey, executor of 0
4845016 2309957 2309957 plaintiff Grene Thomas   593232 593232 Grene, Thomas, of Berkewey 1
4863007 2315408 2315408 defendant Ode William yeoman 593232 593232 Ode, William, of Berkewey, yeoman 0
4863972 2315706 2315706 defendant Ode William yeoman 593232 593232 Ode, William, of Berkewey, yeoman 0
4871152 2317954 2317954 defendant Bateman John ostler 593232 593232 Bateman, John, of Berkewey, ostler 1
4877409 2319888 2319888 defendant Ode William yeoman 593232 593232 Ode, William, of Berkewey, yeoman 0
4877410 2319888 2319888 defendant Reve William yeoman 593232 593232 Reve, William, of Berkewey, yeoman 1
4945868 2340692 2340692 defendant Baker John husbandman 593232 593232 Baker, John, of Berkewey, husbandman 0
4945869 2340692 2340692 defendant Baker Thomas husbandman 593232 593232 Baker, Thomas, of Berkewey, husbandman 1
4953666 2343059 2343059 defendant Seton William clerk 593232 593232 Seton, William, of Berkewey, clerk 4
5033417 2366655 2366655 defendant Baker John yeoman 593232 593232 Baker, John, of Berkewey, yeoman 0
5041564 2369080 2369080 defendant Stalybras Thomas milner 593232 593232 Stalybras, Thomas, of Berkewey, milner 0
5070174 2377574 2377574 defendant Rogger William butcher 593232 593232 Rogger, William, of Berkewey, butcher 3
5359671 2463062 2463062 defendant Cook William husbandman 593232 593232 Cook, William, of Berkewey, husbandman 0
5409946 2477946 2477946 defendant Wombewell Robert (legal representative) 593232 593232 Wombewell, Robert, of Berkewey, innholder, executrix of 0
5423636 2482034 2482034 defendant Wombewell Robert (legal representative) 593232 593232 Wombewell, Robert, of Berkewey, innholder, executrix of 0
5442870 2487779 2487779 defendant Wombewell Robert (legal representative) 593232 593232 Wombewell, Robert, of Berkewey, innholder, executrix of 0
5481524 2499402 2499402 defendant Grevell or Grenell John husbandman 593232 593232 Grevell or Grenell, John, of Berkewey, husbandman 0
5481525 2499402 2499402 defendant Taberer John laborer 593232 593232 together with Taberer, John, of Berkewey, laborer 1
5481526 2499402 2499402 defendant Sparowe Robert laborer 593232 593232 Sparowe, Robert, of Berkewey, laborer 2
5481531 2499404 2499404 defendant Taberer John laborer 593232 593232 Taberer, John, of Berkewey, laborer 0
5481532 2499404 2499404 defendant Sparowe Robert laborer 593232 593232 Sparowe, Robert, of Berkewey, laborer 1
5510034 2507977 2507977 defendant Newenam John, junior husbandman 593232 593232 Newenam, John, junior, of Berkewey, husbandman 0
5536955 2516044 2516044 defendant Skynner John innholder 593232 593232 Skynner, John, of Berkewey, innholder 0
5577530 2528034 2528034 defendant Stevyn William husbandman 593232 593232 Stevyn, William, of Berkewey, husbandman 1
5587878 2531219 2531219 defendant Taillour Robert tailor 593232 593232 Taillour, Robert, of Berkewey, tailor 2
5587879 2531219 2531219 defendant Grenehill John husbandman 593232 593232 Grenehill, John, of Berkewey, husbandman 3

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);