names

95 rows where place_id = 596169

✎ 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
3623450 1874868 1874868 defendant Hunt John yeoman 596169 596169 Hunt, John, of Clopham, yeoman 0
3779218 1951221 1951221 defendant Browne Henry husbandman 596169 596169 Browne, Henry, of Clopham, husbandman 0
3817926 1963525 1963525 defendant FitzJwefferey John esq 596169 596169 FitzJwefferey, John, of Clopham, esq 0
3867878 1979490 1979490 defendant Gale William husbandman 596169 596169 Gale, William, of Clopham, husbandman 0
3893540 1988065 1988065 defendant Fage Thomas husbandman 596169 596169 Fage, Thomas, of Clopham, husbandman 2
4499624 2200521 2200521 defendant Smyth William   596169 596169 Smyth, William, of Clopham 3
4523646 2207723 2207723 defendant Smyth William   596169 596169 Smyth, William, of Clopham 2
4536858 2211802 2211802 defendant fitz Richard John, sen   596169 596169 fitz Richard, John, sen, of Clopham 0
4548139 2215356 2215356 defendant Lamborn William   596169 596169 Lamborn, William, of Clopham 0
4588740 2227859 2227859 plaintiff Lambourne Richard   596169 596169 Lambourne, Richard, of Clopham 0
4599247 2230977 2230977 defendant Croft John   596169 596169 Croft, John, of Clopham 0
4630879 2240550 2240550 plaintiff Swanescombe John   596169 596169 Swanescombe, John, of Clopham 0
4630898 2240557 2240557 plaintiff Swaunescombe John   596169 596169 Swaunescombe, John, of Clopham 0
4665889 2250807 2250807 defendant Cook John husbandman 596169 596169 Cook, John, of Clopham, husbandman 0
4673253 2257275 2257275 plaintiff Crone Richard husbandman 596169 596169 Crone, Richard, of Clopham, husbandman, on his own account 0
4675395 2257914 2257914 plaintiff fitz rychard John   596169 596169 fitz rychard, John, of Clopham 0
4692454 2263158 2263158 defendant Hayle John husbandman 596169 596169 Hayle, John, of Clopham, husbandman 0
4692455 2263158 2263158 defendant fitz Rychard Thomas husbandman 596169 596169 fitz Rychard, Thomas, of Clopham, husbandman 1
4700758 2265637 2265637 plaintiff fitz Rychard John   596169 596169 fitz Rychard, John, of Clopham 0
4701574 2265887 2265887 defendant Hayle John yeoman 596169 596169 Hayle, John, of Clopham, yeoman 0
4723023 2272510 2272510 plaintiff Croft John   596169 596169 Croft, John, of Clopham 0
4730735 2274813 2274813 defendant fitz Richard Thomas yeoman 596169 596169 fitz Richard, Thomas, of Clopham, yeoman 0
4731645 2275091 2275091 defendant Hayle John yeoman 596169 596169 Hayle, John, of Clopham, yeoman 0
4731646 2275091 2275091 defendant More John of the husbandman 596169 596169 More, John of the, of Clopham, husbandman 1
4731647 2275091 2275091 defendant Pecat John husbandman 596169 596169 Pecat, John, of Clopham, husbandman 2
4740119 2277626 2277626 defendant fitz Richardes Thomas husbandman 596169 596169 fitz Richardes, Thomas, of Clopham, husbandman 1
4746430 2279450 2279450 defendant Hayle John husbandman 596169 596169 Hayle, John, of Clopham, husbandman 0
4759916 2283438 2283438 defendant Croft John husbandman 596169 596169 Croft, John, of Clopham, husbandman 0
4765680 2285260 2285260 defendant fitz Richard Thomas husbandman 596169 596169 fitz Richard, Thomas, of Clopham, husbandman 1
4789650 2292830 2292830 defendant Lore William husbandman 596169 596169 Lore, William, of Clopham, husbandman 2
4793941 2294233 2294233 defendant Hayle John yeoman 596169 596169 Hayle, John, of Clopham, yeoman 0
4799227 2295938 2295938 plaintiff Tilly Henry (legal representative) 596169 596169 Tilly, Henry, of Clopham, or of Suth Lambhithe, executors of 0
4815017 2300808 2300808 defendant Hale John husbandman 596169 596169 Hale, John, of Clopham, husbandman 1
4838950 2308114 2308114 defendant Beere Thomas husbandman 596169 596169 Beere, Thomas, of Clopham, husbandman 1
4860389 2314611 2314611 defendant Croft John husbandman 596169 596169 Croft, John, of Clopham, husbandman 0
4889832 2323612 2323612 plaintiff Cokayn Grace (legal representative) 596169 596169 Cokayn, Grace, of Clopham, executors of 0
4889836 2323612 2323612 defendant FitzRychard John husbandman 596169 596169 FitzRychard, John, of Clopham, husbandman 0
4894070 2324845 2324845 plaintiff Cokayn Grace (legal representative) 596169 596169 Cokayn, Grace, of Clopham, executors of 0
4894074 2324845 2324845 defendant FitzRichard John husbandman 596169 596169 FitzRichard, John, of Clopham, husbandman 0
4895506 2325261 2325261 defendant Hayle John husbandman 596169 596169 Hayle, John, of Clopham, husbandman 3
4898691 2326241 2326241 defendant Est William husbandman 596169 596169 Est, William, of Clopham, husbandman 0
4899785 2326569 2326569 defendant Crofte John husbandman 596169 596169 Crofte, John, of Clopham, husbandman 0
4903934 2327847 2327847 defendant Est William husbandman 596169 596169 Est, William, of Clopham, husbandman 0
4904235 2327934 2327934 defendant Hayle John husbandman 596169 596169 Hayle, John, of Clopham, husbandman 3
4963428 2345973 2345973 defendant Bocher John smith 596169 596169 Bocher, John, of Clopham, smith 0
4973959 2349173 2349173 defendant Guddy John husbandman 596169 596169 Guddy, John, of Clopham, husbandman 1
4975313 2349573 2349573 defendant Sturte John yeoman 596169 596169 Sturte, John, of Clopham, yeoman 0
4976652 2349975 2349975 defendant Sweyn Simon smith 596169 596169 Sweyn, Simon, of Clopham, smith 1
4976653 2349975 2349975 defendant Bayhous John carpenter 596169 596169 Bayhous, John, of Clopham, carpenter 2
4993011 2354795 2354795 plaintiff Dolle John   596169 596169 Dolle, John, of Clopham 0
5063792 2375701 2375701 defendant FitzRichard John husbandman 596169 596169 FitzRichard, John, of Clopham, husbandman 0
5063793 2375701 2375701 defendant Bere Thomas husbandman 596169 596169 Bere, Thomas, of Clopham, husbandman 1
5103457 2387437 2387437 defendant Croft John, junior husbandman 596169 596169 Croft, John, junior, of Clopham, husbandman 0
5153008 2402022 2402022 plaintiff Horsham Robert (legal representative) 596169 596169 Horsham, Robert, of Clopham, clerk & parson, executor of 0
5170593 2407121 2407121 plaintiff Horsham Robert (legal representative) 596169 596169 Horsham, Robert, of Clopham, parson, executor of 0
5188374 2412314 2412314 plaintiff Horsham Robert (legal representative) 596169 596169 Horsham, Robert, of Clopham, parson & clerk, executor of 0
5242250 2427935 2427935 defendant Fownteyn John esq 596169 596169 Fownteyn, John, of Clopham, esq 1
5242251 2427935 2427935 defendant Godwyn Richard husbandman 596169 596169 Godwyn, Richard, of Clopham, husbandman 2
5242254 2427936 2427936 defendant Fownteyn John esq 596169 596169 Fownteyn, John, of Clopham, esq 1
5242255 2427936 2427936 defendant Godwyn Richard husbandman 596169 596169 Godwyn, Richard, of Clopham, husbandman 2
5255796 2431935 2431935 defendant Burys William gent 596169 596169 Burys, William, of Clopham, gent 0
5276827 2438304 2438304 defendant atte Well Richard husbandman 596169 596169 atte Well, Richard, of Clopham, husbandman 0
5296885 2444079 2444079 defendant Attwell alias Weller Richard husbandman 596169 596169 Attwell alias Weller, Richard, of Clopham, husbandman 0
5379803 2469267 2469267 defendant More John husbandman 596169 596169 More, John, of Clopham, husbandman 0
5379804 2469267 2469267 defendant Goion Thomas husbandman 596169 596169 Goion, Thomas, of Clopham, husbandman 1
5379805 2469267 2469267 defendant Frererichard Richard husbandman 596169 596169 Frererichard, Richard, of Clopham, husbandman 2
5380484 2469470 2469470 defendant More John husbandman 596169 596169 More, John, of Clopham, husbandman 0
5380485 2469470 2469470 defendant Goion Thomas husbandman 596169 596169 Goion, Thomas, of Clopham, husbandman 1
5380486 2469470 2469470 defendant Frererichard Richard husbandman 596169 596169 Frererichard, Richard, of Clopham, husbandman 2
5385116 2470818 2470818 defendant More John husbandman 596169 596169 More, John, of Clopham, husbandman 0
5385117 2470818 2470818 defendant Boion Thomas husbandman 596169 596169 Boion, Thomas, of Clopham, husbandman 1
5385118 2470818 2470818 defendant Frere Richard Richard husbandman 596169 596169 Frere Richard, Richard, of Clopham, husbandman 2
5385120 2470819 2470819 defendant More John husbandman 596169 596169 More, John, of Clopham, husbandman 0
5385121 2470819 2470819 defendant Boion Thomas husbandman 596169 596169 Boion, Thomas, of Clopham, husbandman 1
5385122 2470819 2470819 defendant Frere Richard Richard husbandman 596169 596169 Frere Richard, Richard, of Clopham, husbandman 2
5410393 2478059 2478059 defendant More John husbandman 596169 596169 More, John, of Clopham, husbandman 0
5410394 2478059 2478059 defendant Goion Thomas husbandman 596169 596169 Goion, Thomas, of Clopham, husbandman 1
5410395 2478059 2478059 defendant Frere Richard Richard husbandman 596169 596169 Frere Richard, Richard, of Clopham, husbandman 2
5421184 2481266 2481266 defendant More John yeoman 596169 596169 More, John, of Clopham, yeoman 0
5424215 2482207 2482207 defendant More John husbandman 596169 596169 More, John, of Clopham, husbandman 0
5424216 2482207 2482207 defendant Goion Thomas husbandman 596169 596169 Goion, Thomas, of Clopham, husbandman 1
5424217 2482207 2482207 defendant Frere Richard Richard husbandman 596169 596169 Frere Richard, Richard, of Clopham, husbandman 2
5424230 2482213 2482213 defendant More John husbandman 596169 596169 More, John, of Clopham, husbandman 0
5424231 2482213 2482213 defendant Goion Thomas husbandman 596169 596169 Goion, Thomas, of Clopham, husbandman 1
5424232 2482213 2482213 defendant Frere Richard Richard husbandman 596169 596169 Frere Richard, Richard, of Clopham, husbandman 2
5440414 2487034 2487034 defendant More John yeoman 596169 596169 More, John, of Clopham, yeoman 0
5440416 2487035 2487035 defendant More John yeoman 596169 596169 More, John, of Clopham, yeoman 0
5440418 2487036 2487036 defendant More John yeoman 596169 596169 More, John, of Clopham, yeoman 0
5471835 2496528 2496528 defendant More John yeoman 596169 596169 More, John, of Clopham, yeoman 0
5480753 2499206 2499206 defendant More John husbandman 596169 596169 More, John, of Clopham, husbandman 0
5480758 2499207 2499207 defendant More John yeoman 596169 596169 More, John, of Clopham, yeoman 0
5596759 2533905 2533905 defendant Lyng William yeoman 596169 596169 Lyng, William, of Clopham, yeoman 0
5608451 2537544 2537544 defendant More John husbandman 596169 596169 More, John, of Clopham, husbandman 0
5608452 2537544 2537544 defendant Goion or Goron Thomas husbandman 596169 596169 Goion or Goron, Thomas, of Clopham, husbandman 1
5632069 2554052 2554052 defendant Seynt Owayn Patrick esq 596169 596169 Seynt Owayn, Patrick, of Clopham, esq 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);