names

50 rows where place_id = 589043

✎ 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
3596364 1866496 1866496 defendant Hardyngham William clerk 589043 589043 Hardyngham, William, of North Byrlyngham, clerk 1
3596366 1866496 1866496 defendant Pekeryng Thomas husbandman 589043 589043 Pekeryng, Thomas, of North Byrlyngham, clerk, husbandman 3
3599931 1867634 1867634 plaintiff Wattys John yeoman 589043 589043 Wattys, John, of North Byrlyngham, yeoman 0
3604311 1869013 1869013 plaintiff Goodwyn Ralph yeoman 589043 589043 Goodwyn, Ralph, of North Byrlyngham, yeoman 1
3604380 1869037 1869037 plaintiff Goodwyn Ralph yeoman 589043 589043 Goodwyn, Ralph, of North Byrlyngham, yeoman 0
3606757 1869787 1869787 defendant Hadryngham William yeoman 589043 589043 Hadryngham, William, of North Byrlyngham, yeoman 5
3853633 1974766 1974766 defendant Hyll Thomas husbandman 589043 589043 Hyll, Thomas, of North Byrlyngham, husbandman 0
3853634 1974766 1974766 defendant Grynt or Erynt Thomas husbandman 589043 589043 Grynt or Erynt, Thomas, of North Byrlyngham, husbandman 1
4759698 2283380 2283380 defendant Dennes John yeoman 589043 589043 Dennes, John, of North Byrlyngham, yeoman 4
4881904 2321238 2321238 defendant Helfeld alias Hornyng John yeoman 589043 589043 Helfeld alias Hornyng, John, of North Byrlyngham, yeoman 3
4888107 2323086 2323086 defendant Hardyngham John, junior husbandman 589043 589043 Hardyngham, John, junior, of North Byrlyngham, husbandman 0
4888108 2323086 2323086 defendant Hardyngham Thomas husbandman 589043 589043 Hardyngham, Thomas, of North Byrlyngham, husbandman 1
4931970 2336386 2336386 defendant atte Lede Nicholas carpenter 589043 589043 atte Lede, Nicholas, of North Byrlyngham, carpenter 1
4958438 2344493 2344493 defendant Nycollys William clerk 589043 589043 Nycollys, William, of North Byrlyngham, clerk 0
5257997 2432622 2432622 defendant Hardyngham John, senior yeoman 589043 589043 Hardyngham, John, senior, of North Byrlyngham, yeoman 0
5277783 2438588 2438588 defendant Hardyngham William clerk 589043 589043 Hardyngham, William, of North Byrlyngham, clerk 0
5277785 2438588 2438588 defendant Hardyngham John, junior laborer 589043 589043 Hardyngham, John, junior, of North Byrlyngham, laborer 2
5280353 2439331 2439331 defendant Hardyngham William clerk 589043 589043 (Hardyngham, William, of North Byrlyngham, clerk 13
5285731 2440855 2440855 plaintiff Hardyngham Thomas (legal representative) 589043 589043 Hardyngham, Thomas, of North Byrlyngham, yeoman, executor of 0
5288814 2441741 2441741 defendant Methewold Thomas husbandman 589043 589043 Methewold, Thomas, of North Byrlyngham, husbandman 1
5291917 2442642 2442642 defendant Baxstere alias Couper John barber or husbandman 589043 589043 Baxstere alias Couper, John, of North Byrlyngham, or of Southwode, barber or husbandman 0
5301754 2445482 2445482 defendant Methewold Thomas yeoman 589043 589043 Methewold, Thomas, of North Byrlyngham, yeoman 2
5314538 2449379 2449379 defendant Deynes Robert yeoman 589043 589043 Deynes, Robert, of North Byrlyngham, yeoman 1
5324292 2452357 2452357 defendant Pykeryng Thomas yeoman 589043 589043 Pykeryng, Thomas, of North Byrlyngham, yeoman 0
5324295 2452357 2452357 defendant Bully John yeoman 589043 589043 Bully, John, of North Byrlyngham, yeoman 3
5330889 2454308 2454308 defendant Herdyngham William clerk 589043 589043 Herdyngham, William, of North Byrlyngham, clerk 0
5349380 2459937 2459937 defendant Deynes Robert yeoman 589043 589043 Deynes, Robert, of North Byrlyngham, yeoman 0
5352708 2460937 2460937 defendant Hardyngham William yeoman 589043 589043 Hardyngham, William, of North Byrlyngham, yeoman 0
5364795 2464653 2464653 defendant Towenesend William husbandman 589043 589043 Towenesend, William, of North Byrlyngham, husbandman 4
5364801 2464654 2464654 defendant Towenesend William husbandman 589043 589043 Towenesend, William, of North Byrlyngham, husbandman 4
5366991 2465324 2465324 defendant Smyth Henry husbandman 589043 589043 Smyth, Henry, of North Byrlyngham, husbandman 2
5379615 2469211 2469211 defendant Brownyng Robert husbandman 589043 589043 Brownyng, Robert, of North Byrlyngham, husbandman 1
5405323 2476607 2476607 plaintiff Whthyrley John gent 589043 589043 Whthyrley, John, of North Byrlyngham, gent 2
5423141 2481881 2481881 plaintiff Blakke John   589043 589043 Blakke, John, of North Byrlyngham 0
5424213 2482206 2482206 defendant Tympe Thomas husbandman 589043 589043 Tympe, Thomas, of North Byrlyngham St Peter, husbandman 0
5434776 2485340 2485340 defendant Pekeryng Thomas husbandman 589043 589043 Pekeryng, Thomas, of North Byrlyngham, husbandman 3
5442570 2487694 2487694 plaintiff Blake John   589043 589043 Blake, John, of North Byrlyngham 0
5449334 2489690 2489690 defendant Gylberd Robert husbandman 589043 589043 Gylberd, Robert, of North Byrlyngham, husbandman 2
5450077 2489911 2489911 defendant Pykeryng Thomas husbandman 589043 589043 Pykeryng, Thomas, of North Byrlyngham, husbandman 2
5450515 2490035 2490035 defendant Bully John yeoman 589043 589043 Bully, John, of North Byrlyngham, yeoman 0
5450519 2490036 2490036 defendant Pekeryng Thomas yeoman 589043 589043 Pekeryng, Thomas, of North Byrlyngham, yeoman 0
5462674 2493742 2493742 defendant Bulby John yeoman 589043 589043 Bulby, John, of North Byrlyngham, yeoman 0
5473758 2497125 2497125 defendant Pekeryng Thomas husbandman 589043 589043 Pekeryng, Thomas, of North Byrlyngham, husbandman 0
5485655 2500609 2500609 defendant Bully John yeoman 589043 589043 Bully, John, of North Byrlyngham, yeoman 0
5489622 2501777 2501777 defendant Hardyngham William clerk 589043 589043 Hardyngham, William, of North Byrlyngham, clerk 2
5509868 2507926 2507926 plaintiff Goodwyn Ralph yeoman 589043 589043 Goodwyn, Ralph, of North Byrlyngham, yeoman 0
5541265 2517383 2517383 defendant Deynes Robert husbandman 589043 589043 Deynes, Robert, of North Byrlyngham, husbandman 0
5579317 2528608 2528608 defendant Godwynne Ralph yeoman 589043 589043 Godwynne, Ralph, of North Byrlyngham, yeoman 0
5584229 2530136 2530136 plaintiff Gylberd Thomas (legal representative) 589043 589043 Gylberd, Thomas, of North Byrlyngham, yeoman, executors of 0
5584232 2530136 2530136 defendant Deynes John yeoman 589043 589043 Deynes, John, of North Byrlyngham, 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);