names

47 rows where place_id = 587388

✎ 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
3591266 1864893 1864893 defendant Curson Robert husbandman 587388 587388 Curson, Robert, of Brook, husbandman 2
3595080 1866094 1866094 defendant Kybert Robert   587388 587388 Kybert, Robert, of Brook yeoman 2
3607190 1869915 1869915 defendant Calff John, senior husbandman 587388 587388 Calff, John, senior, of Brook, husbandman 0
3609250 1870557 1870557 defendant Boys John smith 587388 587388 Boys, John, of Brook, smith 1
3609257 1870558 1870558 defendant Boys John smith 587388 587388 Boys, John, of Brook, smith 1
3635153 1905793 1905793 defendant Curson John, junior yeoman 587388 587388 Curson, John, junior, of Brook, yeoman 0
3635189 1905801 1905801 defendant Lyng John clerk 587388 587388 Lyng, John, of Brook, clerk 0
3635190 1905801 1905801 defendant Curson John, junior yeoman 587388 587388 Curson, John, junior, of Brook, yeoman 1
3748434 1941445 1941445 defendant Kybard Robert husbandman 587388 587388 Kybard, Robert, of Brook, husbandman 0
3856285 1975584 1975584 defendant Fayerchilde Ralph smith 587388 587388 Fayerchilde, Ralph, of Brook, smith 1
3856289 1975585 1975585 defendant Fayerchyld Ralph smith 587388 587388 Fayerchyld, Ralph, of Brook, smith 1
3877375 1982678 1982678 defendant Kyberd Robert husbandman 587388 587388 Kyberd, Robert, of Brook, husbandman 1
3937830 2002985 2002985 defendant Turnor John weaver 587388 587388 Turnor, John, of Brook, weaver 2
4003589 2026047 2026047 plaintiff Howlet Nicholas yeoman 587388 587388 Howlet, Nicholas, of Brook, yeoman 0
4003590 2026047 2026047 defendant Felmyngham Robert gent 587388 587388 Felmyngham, Robert, of Brook, gent 0
4079011 2052792 2052792 defendant Brereton Sebastian (legal representative) 587388 587388 Brereton, Sebastian, of Brook, husbandman, executor of 2
4494417 2198951 2198951 plaintiff Boteler John   587388 587388 Boteler, John, of Brook 0
4547572 2215176 2215176 defendant Castel Nicholas   587388 587388 Castel, Nicholas, of Brook 0
4614650 2235593 2235593 defendant Barkere Geoffrey   587388 587388 Barkere, Geoffrey, of Brook 0
4695922 2264210 2264210 defendant Castelyn Thomas weaver 587388 587388 Castelyn, Thomas, of Brook, weaver 0
4695923 2264210 2264210 defendant Grym Henry husbandman 587388 587388 Grym, Henry, of Brook, husbandman 1
4707210 2267634 2267634 defendant Moket Henry husbandman 587388 587388 Moket, Henry, of Brook, husbandman 4
4928754 2335420 2335420 defendant Sherman William chapman 587388 587388 Sherman, William, of Brook, chapman 2
4939923 2338872 2338872 plaintiff Cursun John   587388 587388 Cursun, John, of Brook 0
5007128 2358973 2358973 defendant Cook John husbandman 587388 587388 Cook, John, of Brook, husbandman 2
5016851 2361825 2361825 defendant Daden Thomas husbandman 587388 587388 Daden, Thomas, of Brook, husbandman 0
5096900 2385523 2385523 plaintiff Sugge William   587388 587388 Sugge, William, of Brook 0
5096901 2385523 2385523 plaintiff Curson John   587388 587388 Curson, John, of Brook 1
5150410 2401255 2401255 defendant Calff John yeoman 587388 587388 Calff, John, of Brook, yeoman 0
5150411 2401255 2401255 defendant Curson John yeoman 587388 587388 Curson, John, of Brook, yeoman 1
5235474 2425953 2425953 defendant Dadelyn Richard butcher 587388 587388 Dadelyn, Richard, of Brook, butcher 1
5278203 2438721 2438721 defendant Cage William husbandman 587388 587388 Cage, William, of Brook, husbandman 0
5287201 2441277 2441277 defendant Calf John husbandman 587388 587388 Calf, John, of Brook, husbandman 1
5287202 2441277 2441277 defendant Castleyn Henry husbandman 587388 587388 Castleyn, Henry, of Brook, husbandman 2
5287203 2441277 2441277 defendant Castleyn Robert butcher 587388 587388 Castleyn, Robert, of Brook, butcher 3
5299721 2444886 2444886 defendant Rychemond William yeoman 587388 587388 Rychemond, William, of Brook, yeoman 0
5314581 2449393 2449393 defendant Rychemond Robert husbandman 587388 587388 Rychemond, Robert, of Brook, husbandman 0
5314582 2449393 2449393 defendant Rychemond William husbandman 587388 587388 Rychemond, William, of Brook, husbandman 1
5326063 2452889 2452889 defendant Sugge William (legal representative) 587388 587388 Sugge, William, of Brook, yeoman, executor of 0
5354998 2461632 2461632 defendant Dadon Geoffrey husbandman 587388 587388 Dadon, Geoffrey, of Brook, husbandman 2
5375101 2467796 2467796 defendant Dowesyng Robert husbandman 587388 587388 Dowesyng, Robert, of Brook, husbandman 0
5375102 2467796 2467796 defendant Turnour Robert husbandman 587388 587388 Turnour, Robert, of Brook, husbandman 1
5497366 2504150 2504150 defendant Emondys Petronilla widow 587388 587388 Emondys, Petronilla, of Brook, widow 4
5512159 2508666 2508666 defendant Waryn Andrew husbandman 587388 587388 Waryn, Andrew, of Brook, husbandman 2
5512171 2508670 2508670 defendant Kyberd Henry yeoman 587388 587388 Kyberd, Henry, of Brook, yeoman 0
5512172 2508670 2508670 defendant Kyberd Robert   587388 587388 Kyberd, Robert, of Brook 1
5541437 2517434 2517434 defendant Turnour Robert husbandman 587388 587388 Turnour, Robert, of Brook, husbandman 2

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