names

45 rows where place_id = 754360

✎ 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
4419557 2171001 2171001 defendant Clerk Thomas le   754360 754360 Clerk, Thomas le, of Wylughby 2
4421142 2171505 2171505 defendant Freskenay Thomas de master & parson 754360 754360 Freskenay, Thomas de, of Wylughby, master & parson 0
4431021 2174460 2174460 plaintiff Barbour William le   754360 754360 Barbour, William le, of Wylughby 0
4431023 2174461 2174461 plaintiff Barbour William le   754360 754360 Barbour, William le, of Wylughby 0
4431024 2174461 2174461 defendant Shepherde Thomas le   754360 754360 Shepherde, Thomas le, of Wylughby 0
4455858 2186847 2186847 plaintiff Mousele Peter de   754360 754360 Mousele, Peter de, of Wylughby, parson, on his own account 0
4463968 2189402 2189402 defendant Mousle Peter de   754360 754360 Mousle, Peter de, of Wylughby, parson 1
4464087 2189439 2189439 defendant Nausle Peter de   754360 754360 Nausle, Peter de, of Wylughby, parson 1
4469428 2191100 2191100 defendant Neel John   754360 754360 Neel, John, of Wylughby 3
4495944 2199409 2199409 plaintiff Clerk Henry   754360 754360 Clerk, Henry, of Wylughby 0
4495946 2199410 2199410 plaintiff Clerk Henry   754360 754360 Clerk, Henry, of Wylughby 0
4495953 2199411 2199411 plaintiff Clerk Henry   754360 754360 Clerk, Henry, of Wylughby, on his own account 0
4501322 2201019 2201019 defendant Cudriour Jacob   754360 754360 Cudriour, Jacob, of Wylughby 0
4515666 2205321 2205321 plaintiff Clerk Henry   754360 754360 Clerk, Henry, of Wylughby 0
4533228 2210652 2210652 plaintiff Retford John de   754360 754360 Retford, John de, of Wylughby, vicar 0
4537337 2211946 2211946 defendant Snys John   754360 754360 together with Snys, John, of Wylughby 1
4537340 2211947 2211947 defendant Snys John   754360 754360 Snys, John, of Wylughby 0
4586374 2227154 2227154 plaintiff Hert John   754360 754360 Hert, John, of Wylughby 0
4591377 2228658 2228658 plaintiff Mille Richard   754360 754360 Mille, Richard, of Wylughby 0
4591379 2228658 2228658 defendant Mariot Henry   754360 754360 Mariot, Henry, of Wylughby 0
4594333 2229484 2229484 defendant Clerk Henry   754360 754360 Clerk, Henry, of Wylughby 0
4611260 2234585 2234585 plaintiff Clerk Henry   754360 754360 Clerk, Henry, of Wylughby 0
4629139 2240041 2240041 defendant Moller William   754360 754360 Moller, William, of Wylughby 0
4639030 2242931 2242931 plaintiff Clerk Henry   754360 754360 Clerk, Henry, of Wylughby 0
4659556 2248839 2248839 defendant Clerk Thomas gent 754360 754360 Clerk, Thomas, of Wylughby, gent 0
4662036 2249600 2249600 defendant Bayly William husbandman 754360 754360 Bayly, William, of Wylughby, husbandman 2
4681425 2259811 2259811 defendant Roo William   754360 754360 Roo, William, of Wylughby, bailiff 1
4720915 2271875 2271875 plaintiff Bury John   754360 754360 Bury, John, of Wylughby 0
4736546 2276562 2276562 plaintiff Tenelby John de   754360 754360 Tenelby, John de, of Wylughby, parson 0
4738802 2277226 2277226 defendant Stute John chaplain 754360 754360 Stute, John, of Wylughby, chaplain 0
4835134 2306988 2306988 defendant Moller Walter husbandman 754360 754360 Moller, Walter, of Wylughby, husbandman 2
4928499 2335338 2335338 defendant Tofte John husbandman 754360 754360 Tofte, John, of Wylughby, husbandman 3
4958407 2344482 2344482 defendant Dast Robert husbandman 754360 754360 Dast, Robert, of Wylughby, husbandman 1
5113014 2390199 2390199 plaintiff Kemp Thomas   754360 754360 Kemp, Thomas, of Wylughby 0
5115064 2390823 2390823 defendant Maunus Robert husbandman 754360 754360 Maunus, Robert, of Wylughby, husbandman 0
5128517 2394815 2394815 plaintiff Cokerell Richard   754360 754360 Cokerell, Richard, of Wylughby 0
5130832 2395499 2395499 defendant Maumas Robert coser or dealer or broker 754360 754360 Maumas, Robert, of Wylughby, coser or dealer or broker 3
5137898 2397595 2397595 defendant Magnus Robert husbandman 754360 754360 Magnus, Robert, of Wylughby, husbandman 0
5150252 2401207 2401207 defendant Mauneas Robert   754360 754360 Mauneas, Robert, of Wylughby, "coser" 3
5182609 2410670 2410670 plaintiff Cokerell Richard   754360 754360 Cokerell, Richard, of Wylughby 0
5226550 2423429 2423429 defendant Mason Thomas husbandman 754360 754360 Mason, Thomas, of Wylughby, husbandman 0
5226552 2423430 2423430 defendant Mason Thomas husbandman 754360 754360 Mason, Thomas, of Wylughby, husbandman 0
5234984 2425812 2425812 defendant Mannus Robert corser 754360 754360 Mannus, Robert, of Wylughby, corser 0
5612515 2547660 2547660 defendant Susse John   754360 754360 Susse, John, of Wylughby 0
5634710 2554853 2554853 defendant Clyderowe Thomas yeoman 754360 754360 Clyderowe, Thomas, of Wylughby, yeoman 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);