names

41 rows where place_id = 594001

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3614124 1872083 1872083 defendant Frengeham Clement clothmaker 594001 594001 Frengeham, Clement, of Magna Chart, clothmaker 0
3614128 1872084 1872084 defendant Frengeham Clement clothmaker 594001 594001 Frengeham, Clement, of Magna Chart, clothmaker 0
3638491 1906856 1906856 plaintiff Toke John (legal representative) 594001 594001 Toke, John, of Magna Chart, gent, executors of 0
3638496 1906857 1906857 plaintiff Toke John (legal representative) 594001 594001 Toke, John, of Magna Chart, gent, executors of 0
3761974 1945752 1945752 defendant Fraunces Thomas husbandman 594001 594001 Fraunces, Thomas, of Magna Chart, husbandman 2
3838164 1969851 1969851 defendant Fowle Edward husbandman 594001 594001 Fowle, Edward, of Magna Chart, husbandman 0
3848207 1973005 1973005 defendant Rammysden Ambrose clothier 594001 594001 Rammysden, Ambrose, of Magna Chart, clothier 0
3848209 1973006 1973006 defendant Rammysden Ambrose clothier 594001 594001 Rammysden, Ambrose, of Magna Chart, clothier 0
3860873 1977129 1977129 defendant Rammysden Ambrose chapman 594001 594001 Rammysden, Ambrose, of Magna Chart, chapman 1
3863462 1977974 1977974 plaintiff Hunt Thomas tailor 594001 594001 Hunt, Thomas, of Magna Chart, tailor 0
3985008 2019395 2019395 defendant Carpenter Thomas husbandman 594001 594001 Carpenter, Thomas, of Magna Chart, husbandman 1
4063557 2047254 2047254 defendant Nelthorpe John gent 594001 594001 Nelthorpe, John, of Magna Chart, gent 0
4088642 2056238 2056238 defendant Baxster Nathaniel clerk 594001 594001 Baxster, Nathaniel, of Magna Chart, clerk 0
4107480 2062962 2062962 defendant Baxster Nathaniel clerk 594001 594001 Baxster, Nathaniel, of Magna Chart, clerk 0
4787694 2292221 2292221 defendant Goldwell William yeoman 594001 594001 Goldwell, William, of Magna Chart, yeoman 1
4795040 2294590 2294590 defendant Hendenne William husbandman 594001 594001 Hendenne, William, of Magna Chart, husbandman 0
4868941 2317259 2317259 defendant Ketyng William husbandman 594001 594001 Ketyng, William, of Magna Chart, husbandman 0
4871452 2318035 2318035 defendant Ketyng William carpenter 594001 594001 Ketyng, William, of Magna Chart, carpenter 0
4871537 2318067 2318067 defendant Wardacre James barber 594001 594001 Wardacre, James, of Magna Chart, barber 3
4954058 2343178 2343178 defendant Curteys Thomas chaplain 594001 594001 Curteys, Thomas, of Magna Chart, chaplain 0
4968069 2347395 2347395 defendant Cropwode James dyer 594001 594001 Cropwode, James, of Magna Chart, dyer 0
4968071 2347396 2347396 defendant Cropwode James dyer 594001 594001 Cropwode, James, of Magna Chart, dyer 0
4968072 2347396 2347396 defendant Ketyng William laborer 594001 594001 Ketyng, William, of Magna Chart, laborer 1
4968073 2347396 2347396 defendant Heanden Richard laborer 594001 594001 Heanden, Richard, of Magna Chart, laborer 2
4974353 2349296 2349296 defendant Squyer William wheeler 594001 594001 Squyer, William, of Magna Chart, wheeler 0
4980356 2351067 2351067 defendant Ketyng William laborer 594001 594001 Ketyng, William, of Magna Chart, laborer 6
5109812 2389301 2389301 defendant Laurence William baker 594001 594001 Laurence, William, of Magna Chart, baker 0
5118385 2391814 2391814 defendant Vowyll John dyer 594001 594001 Vowyll, John, of Magna Chart, dyer 0
5216868 2420673 2420673 defendant Foule John dyer 594001 594001 Foule, John, of Magna Chart, dyer 1
5224467 2422825 2422825 defendant Mille Edward esq 594001 594001 Mille, Edward, of Magna Chart, esq 0
5246648 2429179 2429179 defendant Hamme John husbandman 594001 594001 Hamme, John, of Magna Chart, husbandman 4
5246650 2429180 2429180 defendant Foule alias Fowghill John yeoman 594001 594001 Foule alias Fowghill, John, of Magna Chart, yeoman 0
5260510 2433420 2433420 defendant Laurens William baker 594001 594001 Laurens, William, of Magna Chart, baker 0
5486064 2500716 2500716 defendant Engeham John esq 594001 594001 Engeham, John, of Magna Chart, esq 0
5500078 2504978 2504978 defendant Vowyll John (legal representative) 594001 594001 Vowyll, John, of Magna Chart, dyer, administrator of 0
5500079 2504978 2504978 defendant Fogill William clothmaker 594001 594001 Fogill, William, of Magna Chart, clothmaker 1
5500727 2505159 2505159 defendant Sprotte Thomas husbandman 594001 594001 Sprotte, Thomas, of Magna Chart, husbandman 0
5514572 2509405 2509405 defendant Vowyll John (legal representative) 594001 594001 Vowyll, John, of Magna Chart, dyer, administrator of 0
5514573 2509405 2509405 defendant Fogill William clothmaker 594001 594001 Fogill, William, of Magna Chart, clothmaker 1
5523336 2512130 2512130 plaintiff Fowele William (legal representative) 594001 594001 Fowele, William, of Magna Chart, executors of 0
5523340 2512130 2512130 defendant Clement Thomas carpenter 594001 594001 Clement, Thomas, of Magna Chart, carpenter 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);