names

39 rows where place_id = 598300

✎ 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
3631898 1904788 1904788 plaintiff Halle William gent 598300 598300 Halle, William, of Wedon, gent 0
3645665 1909046 1909046 plaintiff Halle William gent 598300 598300 Halle, William, of Wedon, gent 0
3645926 1909117 1909117 defendant Bysshop Richard husbandman 598300 598300 Bysshop, Richard, of Wedon, husbandman 0
3675067 1918233 1918233 defendant Forest William butcher 598300 598300 Forest, William, of Wedon, butcher 0
3699768 1926151 1926151 defendant Clerk Richard husbandman 598300 598300 Clerk, Richard, of Wedon, husbandman 1
3733294 1936646 1936646 defendant Gamme Henry husbandman 598300 598300 Gamme, Henry, of Wedon, husbandman 1
3806095 1959834 1959834 defendant Gostwyke Robert clerk 598300 598300 Gostwyke, Robert, of Wedon, clerk 0
3823747 1965325 1965325 defendant Gostwyke Robert clerk 598300 598300 Gostwyke, Robert, of Wedon, clerk 0
3827255 1966391 1966391 defendant Howes John husbandman 598300 598300 Howes, John, of Wedon, husbandman 1
3835203 1968949 1968949 defendant Horsfull alias Horsley Henry butcher 598300 598300 Horsfull alias Horsley, Henry, of Wedon, butcher 0
3922573 1997865 1997865 defendant Howse John husbandman 598300 598300 Howse, John, of Wedon, husbandman 1
4327115 2139402 2139402 defendant Billing John yeoman 598300 598300 Billing, John, of Wedon, yeoman 1
4439335 2181571 2181571 defendant Holerigg Richard   598300 598300 Holerigg, Richard, of Wedon 0
4501907 2201196 2201196 defendant Billyng Henry   598300 598300 Billyng, Henry, of Wedon 0
4501908 2201196 2201196 defendant Bocher Robert   598300 598300 Bocher, Robert, of Wedon, son of Thomas 1
4563798 2220246 2220246 plaintiff Rothewell Richard   598300 598300 Rothewell, Richard, of Wedon 0
4590365 2228348 2228348 plaintiff Rothewell Richard   598300 598300 Rothewell, Richard, of Wedon 1
4617025 2236334 2236334 defendant Campion Richard   598300 598300 Campion, Richard, of Wedon 0
4633564 2241351 2241351 defendant Roper Robert   598300 598300 Roper, Robert, of Wedon 0
4666754 2255331 2255331 defendant Rothewell Thomas husbandman 598300 598300 Rothewell, Thomas, of Wedon, husbandman 0
4667374 2255517 2255517 defendant Frankleyn John (legal representative) 598300 598300 Frankleyn, John, of Wedon, yeoman, executor of 1
4675792 2258038 2258038 plaintiff Frensshe Henry   598300 598300 Frensshe, Henry, of Wedon 0
4891507 2324080 2324080 plaintiff Longe John, junior   598300 598300 Longe, John, junior, of Wedon 0
4947740 2341279 2341279 defendant Carpenter alias S- John husbandman 598300 598300 Carpenter alias S-, John, of Wedon, husbandman 0
4976208 2349836 2349836 defendant Smyth John husbandman 598300 598300 Smyth, John, of Wedon, husbandman 0
4976209 2349836 2349836 defendant Carter John husbandman 598300 598300 Carter, John, of Wedon, husbandman 1
4976210 2349836 2349836 defendant Rothewell Walter laborer 598300 598300 Rothewell, Walter, of Wedon, laborer 2
5000009 2356883 2356883 plaintiff Long John   598300 598300 Long, John, of Wedon 0
5039866 2368565 2368565 defendant Smyth John husbandman 598300 598300 Smyth, John, of Wedon, husbandman 0
5052586 2372367 2372367 defendant Neweman Thomas husbandman 598300 598300 Neweman, Thomas, of Wedon, husbandman 0
5097538 2385709 2385709 defendant Fyppes Richard yeoman 598300 598300 Fyppes, Richard, of Wedon, yeoman 1
5097539 2385709 2385709 defendant Longe Richard farmer 598300 598300 Longe, Richard, of Wedon, farmer 2
5271921 2436871 2436871 defendant Brothers Simon yeoman 598300 598300 Brothers, Simon, of Wedon, yeoman 1
5271925 2436872 2436872 defendant Brothers Simon yeoman 598300 598300 Brothers, Simon, of Wedon, yeoman 1
5520452 2511215 2511215 defendant Rolffe John husbandman 598300 598300 Rolffe, John, of Wedon, husbandman 3
5520453 2511215 2511215 defendant Roshwell Richard husbandman 598300 598300 Roshwell, Richard, of Wedon, husbandman 4
5520454 2511215 2511215 defendant Piers William husbandman 598300 598300 Piers, William, of Wedon, husbandman 5
5520455 2511215 2511215 defendant Longe William husbandman 598300 598300 Longe, William, of Wedon, husbandman 6
5520456 2511215 2511215 defendant House Richard husbandman 598300 598300 House, Richard, of Wedon, husbandman 7

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