names

48 rows where place_id = 589930

✎ 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
3599301 1867425 1867425 defendant Lewen Agnes widow 589930 589930 Lewen, Agnes, of Oudeby, widow 1
3635301 1905833 1905833 plaintiff Oudeby Richard gent 589930 589930 Oudeby, Richard, of Oudeby, gent 0
3653635 1911399 1911399 defendant Oudeby Richard gent 589930 589930 Oudeby, Richard, of Oudeby, gent 0
3710391 1929569 1929569 defendant Stretford Thomas yeoman 589930 589930 Stretford, Thomas, of Oudeby, yeoman 0
3790615 1954888 1954888 defendant Knyght Robert husbandman 589930 589930 Knyght, Robert, of Oudeby, husbandman 0
3790616 1954888 1954888 defendant Boneham John husbandman 589930 589930 Boneham, John, of Oudeby, husbandman 1
4423430 2172178 2172178 defendant Thynden John de   589930 589930 Thynden, John de, of Oudeby, rector 0
4545525 2214523 2214523 plaintiff Bocher Alexander   589930 589930 Bocher, Alexander, of Oudeby 0
4545527 2214523 2214523 defendant Shepherd Thomas   589930 589930 Shepherd, Thomas, of Oudeby 1
4560425 2219201 2219201 defendant Gaylard John   589930 589930 Gaylard, John, of Oudeby 0
4618382 2236762 2236762 plaintiff Ulse Robert   589930 589930 (Ulse, Robert, of Oudeby 1
4618389 2236762 2236762 defendant Plasterer Thomas   589930 589930 Plasterer, Thomas, of Oudeby 3
4618560 2236813 2236813 defendant Waleys John   589930 589930 Waleys, John, of Oudeby 0
4618561 2236813 2236813 defendant Plasterer Thomas   589930 589930 Plasterer, Thomas, of Oudeby 1
4618562 2236813 2236813 defendant Gayllard Roger   589930 589930 Gayllard, Roger, of Oudeby 2
4625062 2238804 2238804 defendant Brokesby William   589930 589930 Brokesby, William, of Oudeby 0
4642480 2243924 2243924 defendant Waleys John   589930 589930 Waleys, John, of Oudeby 0
4642481 2243924 2243924 defendant Plasterer Thomas   589930 589930 Plasterer, Thomas, of Oudeby 1
4642482 2243924 2243924 defendant Gaylerd Roger   589930 589930 Gaylerd, Roger, of Oudeby 2
4718510 2271132 2271132 defendant Steynour Richard stainer 589930 589930 Steynour, Richard, of Oudeby, stainer 0
4725305 2273205 2273205 defendant Coke Roger gent 589930 589930 Coke, Roger, of Oudeby, gent 1
4735923 2276386 2276386 defendant Oudeby Thomas gent 589930 589930 Oudeby, Thomas, of Oudeby, gent 0
4747562 2279792 2279792 defendant Ulf Thomas esq 589930 589930 Ulf, Thomas, of Oudeby, esq 0
4762687 2284309 2284309 defendant Wardeman William husbandman 589930 589930 Wardeman, William, of Oudeby, husbandman 1
4764229 2284804 2284804 defendant Campion Richard   589930 589930 together with Campion, Richard, of Oudeby, bailiff 2
4764233 2284805 2284805 defendant Campion Richard   589930 589930 Campion, Richard, of Oudeby, bailiff 0
4766605 2285548 2285548 defendant Cook Roger gent 589930 589930 Cook, Roger, of Oudeby, gent 0
4769086 2286313 2286313 defendant Cook Roger gent 589930 589930 Cook, Roger, of Oudeby, gent 0
4770601 2286786 2286786 defendant Davy John husbandman 589930 589930 Davy, John, of Oudeby, husbandman 0
4785508 2291489 2291489 defendant Cook Roger gent 589930 589930 Cook, Roger, of Oudeby, gent 0
4793634 2294121 2294121 defendant Cook Roger gent 589930 589930 Cook, Roger, of Oudeby, gent 0
4800166 2296228 2296228 defendant Oudeby John, senior esq 589930 589930 Oudeby, John, senior, of Oudeby, esq 1
4823387 2303402 2303402 defendant Oudeby Thomas gent 589930 589930 Oudeby, Thomas, of Oudeby, gent 0
4825514 2304024 2304024 defendant Gowedeby William husbandman 589930 589930 Gowedeby, William, of Oudeby, husbandman 0
4855928 2313226 2313226 defendant Clepysby John gent 589930 589930 Clepysby, John, of Oudeby, gent 1
4902733 2327473 2327473 defendant Cook Susan widow 589930 589930 Cook, Susan, of Oudeby, widow 1
4988842 2353614 2353614 defendant Barwell William husbandman 589930 589930 Barwell, William, of Oudeby, husbandman 0
4988843 2353614 2353614 defendant Warmale John   589930 589930 Warmale, John, of Oudeby, servant 1
5099537 2386302 2386302 defendant Power John, senior husbandman 589930 589930 Power, John, senior, of Oudeby, husbandman 1
5220099 2421587 2421587 defendant Aleyn William husbandman 589930 589930 Aleyn, William, of Oudeby, husbandman 0
5220100 2421587 2421587 defendant Ball John husbandman 589930 589930 Ball, John, of Oudeby, husbandman 1
5257365 2432426 2432426 defendant Mason Richard   589930 589930 Mason, Richard, of Oudeby, shepherd 0
5257367 2432427 2432427 defendant Mason Richard   589930 589930 Mason, Richard, of Oudeby, shepherd 0
5268884 2436014 2436014 defendant Faster Thomas husbandman 589930 589930 Faster, Thomas, of Oudeby, husbandman 0
5268885 2436014 2436014 defendant Tokeby Robert husbandman 589930 589930 Tokeby, Robert, of Oudeby, husbandman 1
5273660 2437373 2437373 defendant Atkyns William clerk 589930 589930 Atkyns, William, of Oudeby, clerk 0
5273662 2437374 2437374 defendant Atkyns William clerk 589930 589930 Atkyns, William, of Oudeby, clerk 0
5281706 2439720 2439720 defendant Stanton Richard husbandman 589930 589930 Stanton, Richard, of Oudeby,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);