names

46 rows where place_id = 595288

✎ 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
3619849 1873783 1873783 defendant Hemmyngwey John yeoman 595288 595288 (Hemmyngwey, John, of Waltham Crosse, yeoman 1
3619851 1873783 1873783 defendant Norton John skinner 595288 595288 (Norton, John, of Waltham Crosse, skinner 3
3649862 1910320 1910320 defendant Lucas John husbandman 595288 595288 Lucas, John, of Waltham Crosse, husbandman 0
3673254 1917649 1917649 defendant Kelsey alias Kelsall Gervase yeoman 595288 595288 Kelsey alias Kelsall, Gervase, of Waltham Crosse, yeoman 0
3678461 1919317 1919317 defendant Johnson alias Adams Simon laborer 595288 595288 Johnson alias Adams, Simon, of Waltham Crosse, laborer 1
3692148 1923714 1923714 defendant Blesedale Thomas yeoman 595288 595288 Blesedale, Thomas, of Waltham Crosse, yeoman 0
3708402 1928924 1928924 defendant Pest Robert barber 595288 595288 Pest, Robert, of Waltham Crosse, barber 0
3827903 1966590 1966590 defendant Newman Richard tailor 595288 595288 Newman, Richard, of Waltham Crosse, tailor 0
3858940 1976481 1976481 defendant Bawne Thomas yeoman 595288 595288 Bawne, Thomas, of Waltham Crosse, yeoman 0
3858941 1976481 1976481 defendant Denham John innholder 595288 595288 Denham, John, of Waltham Crosse, innholder 1
3868677 1979766 1979766 defendant Geton Nicholas butcher 595288 595288 Geton, Nicholas, of Waltham Crosse, shoemaker, Swetyng, William, of Stortford, butcher 0
3877824 1982826 1982826 defendant Wyggyn Thomas butcher 595288 595288 Wyggyn, Thomas, of Waltham Crosse, butcher 0
3914560 1995214 1995214 defendant Jekett alias Jekell Richard yeoman 595288 595288 Jekett alias Jekell, Richard, of Waltham Crosse, yeoman 0
4790654 2293164 2293164 plaintiff Langrygge John   595288 595288 Langrygge, John, of Waltham Crosse 0
4942899 2339754 2339754 defendant Walter Magaret widow 595288 595288 Walter, Magaret, of Waltham Crosse, widow 1
4950096 2341997 2341997 defendant Reymond John husbandman 595288 595288 Reymond, John, of Waltham Crosse, husbandman 1
4950097 2341997 2341997 defendant Mayster John miller 595288 595288 Mayster, John, of Waltham Crosse, miller 2
4956997 2344050 2344050 plaintiff Walter Simon (legal representative) 595288 595288 Walter, Simon, of Waltham Crosse, executrix of 0
4983518 2351985 2351985 defendant Reymond John husbandman 595288 595288 Reymond, John, of Waltham Crosse, husbandman 0
5085350 2382109 2382109 defendant Lyster William (legal representative) 595288 595288 Lyster, William, of Waltham Crosse, or of Chesthunte, Herts, yeoman, executrix of 0
5101418 2386829 2386829 defendant Kyrton Robert smith 595288 595288 Kyrton, Robert, of Waltham Crosse, smith 0
5101419 2386829 2386829 defendant Bene Thomas butcher 595288 595288 Bene, Thomas, of Waltham Crosse, butcher 1
5121043 2392584 2392584 plaintiff Sutton John   595288 595288 Sutton, John, of Waltham Crosse 0
5121044 2392584 2392584 defendant Skyrton Robert smith 595288 595288 Skyrton, Robert, of Waltham Crosse, smith 0
5121047 2392584 2392584 defendant Kere John   595288 595288 Kere, John, of Waltham Crosse ostler 3
5121095 2392600 2392600 defendant Beane John butcher 595288 595288 Beane, John, of Waltham Crosse, butcher 0
5121096 2392600 2392600 defendant Boche John butcher 595288 595288 Boche, John, of Waltham Crosse, butcher 1
5123714 2393395 2393395 defendant Keyre John ostler 595288 595288 Keyre, John, of Waltham Crosse, ostler 0
5195598 2414463 2414463 defendant Bene Thomas butcher 595288 595288 Bene, Thomas, of Waltham Crosse, butcher 2
5310511 2448181 2448181 defendant Selby John yeoman 595288 595288 Selby, John, of Waltham Crosse, yeoman 1
5310512 2448181 2448181 defendant Byngley Thomas yeoman 595288 595288 Byngley, Thomas, of Waltham Crosse, yeoman 2
5338788 2456704 2456704 defendant Carpenter Thomas husbandman 595288 595288 Carpenter, Thomas, of Waltham Crosse, husbandman 1
5378360 2468812 2468812 defendant Hans John   595288 595288 Hans, John, of Waltham Crosse, shoe maker 0
5447155 2489040 2489040 defendant Cawthorn John yeoman 595288 595288 Cawthorn, John, of Waltham Crosse, yeoman 0
5471802 2496520 2496520 defendant Multon William   595288 595288 Multon, William, of Waltham Crosse 1
5471803 2496520 2496520 defendant Bothe John   595288 595288 Bothe, John, of Waltham Crosse 2
5499970 2504944 2504944 defendant Ramton or Rainton John osier 595288 595288 Ramton or Rainton, John, of Waltham Crosse, osier 2
5507399 2507208 2507208 defendant Forthe Nicholas hosier or husbandman 595288 595288 Forthe, Nicholas, of Waltham Crosse, hosier or husbandman 0
5517443 2510297 2510297 defendant Rampton John yeoman 595288 595288 Rampton, John, of Waltham Crosse, yeoman 0
5519284 2510877 2510877 defendant Skaunt Thomas butcher 595288 595288 Skaunt, Thomas, of Waltham Crosse, butcher 0
5519285 2510877 2510877 defendant Potter Nicholas innholder 595288 595288 Potter, Nicholas, of Waltham Crosse, innholder 1
5527667 2513233 2513233 defendant Selby John innholder 595288 595288 Selby, John, of Waltham Crosse, innholder 0
5529370 2513700 2513700 defendant Carre Edmund yeoman 595288 595288 Carre, Edmund, of Waltham Crosse, yeoman 0
5529371 2513700 2513700 defendant Selby John innholder 595288 595288 Selby, John, of Waltham Crosse, innholder 1
5537636 2516261 2516261 defendant Hasyll Robert innholder 595288 595288 Hasyll, Robert, of Waltham Crosse, innholder 2
5565390 2524468 2524468 defendant Kelsay Robert innholder 595288 595288 Kelsay, Robert, of Waltham Crosse, innholder 1

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