names

37 rows where place_id = 597020

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626969 1903292 1903292 plaintiff Bedell William esq 597020 597020 Bedell, William, of Hertford, Herts, esq 0
3851718 1974126 1974126 defendant Chester William glover 597020 597020 Chester, William, of Hertford, Herts, glover 1
4665310 2250640 2250640 defendant Burman Richard husbandman 597020 597020 Burman, Richard, of Hertford, Herts, husbandman 4
4692967 2263311 2263311 defendant Hertford Henry draper 597020 597020 Hertford, Henry, of Hertford, Herts, draper 1
4710520 2268649 2268649 defendant Braunceter Henry tailor 597020 597020 Braunceter, Henry, of Hertford, Herts, tailor 0
4747526 2279782 2279782 defendant Barton Thomas gent 597020 597020 Barton, Thomas, of Hertford, Herts, gent 0
4805377 2297888 2297888 defendant Wyke John gent 597020 597020 Wyke, John, of Hertford, Herts, gent 0
4816173 2301143 2301143 defendant Hille William husbandman 597020 597020 Hille, William, of Hertford, Herts, husbandman 1
4836722 2307452 2307452 defendant Fairefax John yeoman 597020 597020 Fairefax, John, of Hertford, Herts, yeoman 0
4836728 2307453 2307453 defendant Farefax John yeoman 597020 597020 Farefax, John, of Hertford, Herts, yeoman 0
4837071 2307552 2307552 defendant Aylbarne Robert fuller 597020 597020 Aylbarne, Robert, of Hertford, Herts, fuller 0
4842688 2309250 2309250 defendant Lyntolf Ralph   597020 597020 Lyntolf, Ralph, of Hertford, Herts, knight 0
4842691 2309251 2309251 defendant Lyntolf Ralph   597020 597020 Lyntolf, Ralph, of Hertford, Herts, knight 0
4843921 2309615 2309615 defendant Esebarne Henry yeoman 597020 597020 Esebarne, Henry, of Hertford, Herts, yeoman 2
4907817 2329007 2329007 defendant Maystre Thomas gent 597020 597020 Maystre, Thomas, of Hertford, Herts, gent 0
4907819 2329007 2329007 defendant Scarlet William gent 597020 597020 Scarlet, William, of Hertford, Herts, gent 2
4916415 2331632 2331632 defendant Fairfax John yeoman 597020 597020 Fairfax, John, of Hertford, Herts, yeoman 0
4919984 2332762 2332762 defendant Hykeman alias Barbour William chapman & barber 597020 597020 Hykeman alias Barbour, William, of Hertford, Herts, chapman & barber 0
4919991 2332764 2332764 defendant Hykeman William chapman 597020 597020 Hykeman, William, of Hertford, Herts, chapman 0
5001676 2357384 2357384 defendant Curteys William yeoman 597020 597020 Curteys, William, of Hertford, Herts, yeoman 0
5011945 2360345 2360345 defendant Arnold Thomas chapman 597020 597020 Arnold, Thomas, of Hertford, Herts, chapman 2
5011951 2360346 2360346 defendant Arnold Thomas chapman 597020 597020 Arnold, Thomas, of Hertford, Herts, chapman 2
5039050 2368326 2368326 defendant West John gent 597020 597020 (West, John, of Hertford, Herts, gent 2
5044876 2370102 2370102 defendant Forster John yeoman 597020 597020 Forster, John, of Hertford, Herts, yeoman 2
5044878 2370103 2370103 defendant Hikman alias Barbour William barber 597020 597020 Hikman alias Barbour, William, of Hertford, Herts, barber 0
5063333 2375566 2375566 defendant Hikman William barber 597020 597020 Hikman, William, of Hertford, Herts, barber 3
5132765 2396077 2396077 defendant Berewyk Thomas butcher 597020 597020 Berewyk, Thomas, of Hertford, Herts, butcher 3
5367846 2465570 2465570 defendant West Thomas collier 597020 597020 West, Thomas, of Hertford, Herts, collier 1
5397278 2474305 2474305 defendant Neweman John yeoman 597020 597020 Neweman, John, of Hertford, Herts, yeoman 3
5410512 2478088 2478088 defendant Neweman John yeoman 597020 597020 Neweman, John, of Hertford, Herts, yeoman 3
5424400 2482262 2482262 defendant Neweman John yeoman 597020 597020 Neweman, John, of Hertford, Herts, yeoman 2
5452634 2490672 2490672 defendant Norrys John   597020 597020 Norrys, John, of Hertford, Herts, yeoman & of Luton, Beds 0
5459097 2492616 2492616 defendant Bensted Edward gent 597020 597020 Bensted, Edward, of Hertford, Herts, gent 3
5460194 2492983 2492983 defendant Sebourn John clerk 597020 597020 Sebourn, John, of Hertford, Herts, clerk 2
5471819 2496525 2496525 defendant Sebourn John clerk 597020 597020 Sebourn, John, of Hertford, Herts, clerk 2
5471825 2496526 2496526 defendant Sebourn John clerk 597020 597020 Sebourn, John, of Hertford, Herts, clerk 2
5471831 2496527 2496527 defendant Sebourn John clerk 597020 597020 Sebourn, John, of Hertford, Herts, clerk 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);