names

59 rows where place_id = 606615

✎ 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
3665894 1915269 1915269 defendant Warde John barber 606615 606615 Warde, John, of Great Dunmowe, barber 2
4440490 2181935 2181935 defendant Tannere John   606615 606615 Tannere, John, of Great Dunmowe 1
4440815 2182043 2182043 defendant Colman Nicholas   606615 606615 Colman, Nicholas, of Great Dunmowe 0
4455662 2186782 2186782 defendant Arnold Robert   606615 606615 Arnold, Robert, of Great Dunmowe 0
4474021 2192527 2192527 defendant Bryketot William   606615 606615 Bryketot, William, of Great Dunmowe, wool man 0
4476865 2193428 2193428 defendant Gauge John   606615 606615 Gauge, John, of Great Dunmowe 0
4479939 2194390 2194390 defendant Gauge John   606615 606615 Gauge, John, of Great Dunmowe 0
4489790 2197519 2197519 defendant Screveyne John   606615 606615 Screveyne, John, of Great Dunmowe 0
4502493 2201363 2201363 defendant Wysman William (legal representative) 606615 606615 Wysman, William, of Great Dunmowe, executors of: (Hayward, John 2
4560902 2219363 2219363 defendant Profyte John   606615 606615 Profyte, John, of Great Dunmowe 0
4561506 2219532 2219532 defendant Prophete John   606615 606615 Prophete, John, of Great Dunmowe 0
4561509 2219533 2219533 defendant Prophete John   606615 606615 Prophete, John, of Great Dunmowe 0
4631256 2240672 2240672 plaintiff Tannere Walter (legal representative) 606615 606615 Tannere, Walter, of Great Dunmowe, executors of 0
4631258 2240672 2240672 plaintiff Skynnere Thomas   606615 606615 Skynnere, Thomas, of Great Dunmowe 2
4669477 2256158 2256158 defendant Seman John smith 606615 606615 Seman, John, of Great Dunmowe, smith 0
4692966 2263311 2263311 defendant Porter John, sen hosier 606615 606615 Porter, John, sen, of Great Dunmowe, hosier 0
4692992 2263318 2263318 defendant Rolf William husbandman 606615 606615 Rolf, William, of Great Dunmowe, husbandman 1
4709251 2268262 2268262 defendant London William carpenter 606615 606615 London, William, of Great Dunmowe, carpenter 0
4719615 2271477 2271477 defendant Asshen Richard laborer 606615 606615 Asshen, Richard, of Great Dunmowe, laborer 0
4739486 2277433 2277433 plaintiff Waterman Thomas   606615 606615 Waterman, Thomas, of Great Dunmowe 3
4739487 2277433 2277433 defendant Fysshe Richard husbandman 606615 606615 Fysshe, Richard, of Great Dunmowe, husbandman 0
4740379 2277697 2277697 defendant Rolff William husbandman 606615 606615 Rolff, William, of Great Dunmowe, husbandman 0
4747008 2279628 2279628 defendant Canteys John fisher 606615 606615 Canteys, John, of Great Dunmowe, fisher 0
4755923 2282236 2282236 defendant Fuller Thomas fuller 606615 606615 Fuller, Thomas, of Great Dunmowe, fuller 0
4811429 2299683 2299683 defendant Templere Thomas husbandman 606615 606615 Templere, Thomas, of Great Dunmowe, husbandman 0
4823901 2303556 2303556 defendant Ponde William butcher 606615 606615 Ponde, William, of Great Dunmowe, butcher 1
4842658 2309239 2309239 defendant Whelere Henry   606615 606615 Whelere, Henry, of Great Dunmowe, wheel wright 1
4922699 2333511 2333511 defendant Marshall Thomas   606615 606615 Marshall, Thomas, of Great Dunmowe, franklin 0
4992242 2354572 2354572 defendant London William husbandman 606615 606615 London, William, of Great Dunmowe, husbandman 0
4992243 2354572 2354572 defendant Fysete John miller 606615 606615 Fysete, John, of Great Dunmowe, miller 1
5038381 2368114 2368114 defendant (illegible) (illegible) yeoman 606615 606615 ---, ---, of Great Dunmowe, yeoman 0
5044490 2369982 2369982 defendant Braybroke John husbandman 606615 606615 Braybroke, John, of Great Dunmowe, husbandman 3
5147555 2400424 2400424 defendant atte Wode Thomas husbandman 606615 606615 atte Wode, Thomas, of Great Dunmowe, husbandman 2
5167209 2406141 2406141 defendant atte Wode Thomas husbandman 606615 606615 atte Wode, Thomas, of Great Dunmowe, husbandman 2
5182529 2410642 2410642 defendant atte Wode John husbandman 606615 606615 atte Wode, John, of Great Dunmowe, husbandman 2
5182533 2410643 2410643 defendant atte Wode John husbandman 606615 606615 atte Wode, John, of Great Dunmowe, husbandman 2
5276280 2438134 2438134 defendant Yerdeley William tanner 606615 606615 Yerdeley, William, of Great Dunmowe, tanner 0
5276283 2438134 2438134 defendant Wolman John tailor 606615 606615 Wolman, John, of Great Dunmowe, tailor 3
5300876 2445224 2445224 defendant Lytyll John husbandman 606615 606615 Lytyll, John, of Great Dunmowe, husbandman 1
5370254 2466285 2466285 defendant Clerk John husbandman 606615 606615 Clerk, John, of Great Dunmowe, husbandman 0
5370258 2466285 2466285 defendant Creke John husbandman 606615 606615 Creke, John, of Great Dunmowe, husbandman 4
5380779 2469557 2469557 defendant Chircheman John   606615 606615 Chircheman, John, of Great Dunmowe 0
5380946 2469607 2469607 defendant Fuller Richard   606615 606615 Fuller, Richard, of Great Dunmowe, notary, alias Lyghtfote, Richard 2
5380950 2469608 2469608 defendant Fuller Richard   606615 606615 Fuller, Richard, of Great Dunmowe, notary, alias Lyghtfote, Richard 2
5380954 2469609 2469609 defendant Fuller Richard   606615 606615 Fuller, Richard, of Great Dunmowe, notary, alias Lyghtfote, Richard 2
5387042 2471361 2471361 defendant Fuller Richard   606615 606615 Fuller, Richard, of Great Dunmowe, notary 0
5387791 2471572 2471572 defendant Vyntener John husbandman 606615 606615 Vyntener, John, of Great Dunmowe, husbandman 0
5389677 2472109 2472109 defendant Hendon William yeoman 606615 606615 Hendon, William, of Great Dunmowe, yeoman 0
5389679 2472109 2472109 defendant Michell Thomas shoemaker 606615 606615 Michell, Thomas, of Great Dunmowe, shoemaker 2
5393530 2473208 2473208 defendant Donny Richard yeoman 606615 606615 Donny, Richard, of Great Dunmowe, yeoman 0
5415855 2479677 2479677 plaintiff Lyghtfote Richard husbandman 606615 606615 Lyghtfote, Richard, of Great dunmowe, husbandman 0
5418620 2480493 2480493 defendant Joynour Thomas yeoman 606615 606615 Joynour, Thomas, of Great Dunmowe, yeoman 1
5428717 2483502 2483502 defendant Hendon William yeoman 606615 606615 Hendon, William, of Great Dunmowe, yeoman 0
5436578 2485872 2485872 defendant Joynour Thomas yeoman 606615 606615 Joynour, Thomas, of Great Dunmowe, yeoman 1
5436583 2485873 2485873 defendant Joynour Thomas yeoman 606615 606615 Joynour, Thomas, of Great Dunmowe, yeoman 1
5451236 2490249 2490249 defendant Joynoure Thomas   606615 606615 Joynoure, Thomas, of Great Dunmowe 1
5610700 2547066 2547066 defendant Wisman William   606615 606615 Wisman, William, of Great Dunmowe 0
5611773 2547418 2547418 plaintiff Brid John   606615 606615 Brid, John, of Great Dunmowe, son of Walter 0
5615833 2548747 2548747 defendant Arnold Richard   606615 606615 Arnold, Richard, of Great Dunmowe 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);