names

34 rows where place_id = 589072

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596423 1866510 1866510 defendant Lampton William husbandman 589072 589072 Lampton, William, of Sutton, Beds, husbandman 0
3597989 1866996 1866996 defendant Flynte Edmund husbandman 589072 589072 Flynte, Edmund, of Sutton, Beds, husbandman 0
3621151 1874162 1874162 defendant Wirall William yeoman 589072 589072 Wirall, William, of Sutton, Beds, yeoman 34
3670626 1916779 1916779 defendant Baldwyn Gilbert husbandman 589072 589072 Baldwyn, Gilbert, of Sutton, Beds, husbandman 0
4348651 2146786 2146786 defendant Neave John yeoman 589072 589072 Neave, John, of Sutton, Beds, yeoman 0
4726744 2273633 2273633 defendant Brampton William husbandman 589072 589072 Brampton, William, of Sutton, Beds, husbandman 2
4727503 2273844 2273844 defendant Goldyng John maltman 589072 589072 Goldyng, John, of Sutton, Beds, maltman 4
4775658 2288382 2288382 defendant Goldyng John maltman 589072 589072 Goldyng, John, of Sutton, Beds, maltman 2
4815965 2301084 2301084 defendant Heyward John husbandman 589072 589072 Heyward, John, of sutton, Beds, husbandman 1
4899684 2326534 2326534 defendant Pulter John pulter 589072 589072 Pulter, John, of Sutton, Beds, pulter 0
5087814 2382817 2382817 defendant More William loader 589072 589072 More, William, of Sutton, Beds, loader 0
5090216 2383508 2383508 defendant Yonghusbond Richard smith 589072 589072 Yonghusbond, Richard, of Sutton, Beds, smith 0
5147644 2400448 2400448 defendant Kyrkeby Richard husbandman 589072 589072 Kyrkeby, Richard, of Sutton, Beds, husbandman 3
5147645 2400448 2400448 defendant Eye William de husbandman 589072 589072 Eye, William de, of Sutton, Beds, husbandman 4
5167260 2406155 2406155 defendant Eye William de husbandman 589072 589072 Eye, William de, of Sutton, Beds, husbandman 3
5167261 2406155 2406155 defendant Kybworth John husbandman 589072 589072 Kybworth, John, of Sutton, Beds, husbandman 4
5182926 2410754 2410754 defendant Eyre William   589072 589072 Eyre, William, of Sutton, Beds, husb 4
5184388 2411172 2411172 defendant Broun Thomas husbandman 589072 589072 Broun, Thomas, of Sutton, Beds, husbandman 0
5203637 2416817 2416817 defendant Eyre William husbandman 589072 589072 Eyre, William, of Sutton, Beds, husbandman 4
5219195 2421337 2421337 defendant Mustell John gent 589072 589072 Mustell, John, of Sutton, Beds, or of London, gent 1
5219200 2421338 2421338 defendant Mustell John gent 589072 589072 Mustell, John, of Sutton, Beds, or of London, gent 1
5342581 2457880 2457880 defendant Hagge Thomas maltman 589072 589072 Hagge, Thomas, of Sutton, Beds, maltman 0
5366432 2465154 2465154 defendant Treser John butcher 589072 589072 Treser, John, of Sutton, Beds, butcher 0
5385052 2470801 2470801 defendant Treser John   589072 589072 Treser, John, of Sutton, Beds 0
5407141 2477101 2477101 defendant Haggys Thomas husbandman 589072 589072 Haggys, Thomas, of Sutton, Beds, husbandman 3
5407146 2477102 2477102 defendant Haggys Thomas husbandman 589072 589072 Haggys, Thomas, of Sutton, Beds, husbandman 3
5447142 2489036 2489036 defendant Burgoyne Thomas yeoman 589072 589072 Burgoyne, Thomas, of Sutton, Beds, yeoman 0
5459616 2492792 2492792 defendant Burgoyne Thomas yeoman 589072 589072 Burgoyne, Thomas, of Sutton, Beds, yeoman 0
5459619 2492793 2492793 defendant Burgoyne Thomas yeoman 589072 589072 Burgoyne, Thomas, of Sutton, Beds, yeoman 0
5471324 2496360 2496360 defendant Burgoyne Thomas yeoman 589072 589072 Burgoyne, Thomas, of Sutton, Beds, yeoman 0
5479584 2498905 2498905 defendant Smyth Thomas husbandman 589072 589072 Smyth, Thomas, of Sutton, Beds, husbandman 1
5479595 2498908 2498908 defendant Smyth Thomas husbandman 589072 589072 Smyth, Thomas, of Sutton, Beds, husbandman 2
5479598 2498909 2498909 defendant Smyth Thomas husbandman 589072 589072 Smyth, Thomas, of Sutton, Beds, husbandman 0
5511623 2508483 2508483 defendant Andrewe John husbandman 589072 589072 Andrewe, John, of Sutton, Beds, husbandman 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);