names

32 rows where place_id = 593484

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612062 1871416 1871416 defendant Sterre John husbandman 593484 593484 Sterre, John, of Bere, husbandman 3
3612063 1871416 1871416 defendant Denys John yeoman 593484 593484 Denys, John, of Bere, yeoman 4
3614037 1872050 1872050 defendant Taylour John husbandman 593484 593484 Taylour, John, of Bere, husbandman 0
3623495 1874879 1874879 defendant Dyot John husbandman 593484 593484 Dyot, John, of Bere, husbandman 6
3709418 1929245 1929245 defendant Lanyford Geoffrey smith 593484 593484 Lanyford, Geoffrey, of Bere, smith 1
3715593 1931162 1931162 defendant Pounde William esq 593484 593484 (Pounde, William, of Bere, esq 1
4453902 2186237 2186237 defendant Elyot Thomas   593484 593484 Elyot, Thomas, of Bere 0
4582131 2225847 2225847 defendant Rewell John   593484 593484 Rewell, John, of Bere 0
4655319 2247552 2247552 defendant Croppe Walter   593484 593484 Croppe, Walter, of Bere, shepherd 0
4688359 2261925 2261925 defendant Turbervyle Robert   593484 593484 Turbervyle, Robert, of Bere, knight 0
4695354 2264027 2264027 defendant Merlyng Walter   593484 593484 Merlyng, Walter, of Bere 5
4705557 2267106 2267106 defendant Poulet William   593484 593484 Poulet, William, of Bere 0
4705559 2267107 2267107 defendant Poulet William gent 593484 593484 Poulet, William, of Bere, gent 0
4879173 2320425 2320425 defendant Hurdewyk Robert gent 593484 593484 Hurdewyk, Robert, of Bere, gent 0
4883873 2321865 2321865 defendant Hurdewyk Robert gent 593484 593484 Hurdewyk, Robert, of Bere, gent 0
4972837 2348813 2348813 defendant Mone Richard laborer 593484 593484 Mone, Richard, of Bere, laborer 1
4979378 2350794 2350794 defendant Sturre Richard husbandman 593484 593484 Sturre, Richard, of Bere, husbandman 6
4979379 2350794 2350794 defendant Yong William husbandman 593484 593484 Yong, William, of Bere, husbandman 7
4979380 2350794 2350794 defendant Helyer William husbandman 593484 593484 Helyer, William, of Bere, husbandman 8
5001661 2357379 2357379 defendant Gryndell Roger husbandman 593484 593484 Gryndell, Roger, of Bere, husbandman 0
5055985 2373362 2373362 defendant Horwode John yeoman 593484 593484 Horwode, John, of Bere, yeoman 0
5136258 2397122 2397122 defendant Longdon William   593484 593484 Longdon, William, of Bere, parson 2
5172751 2407760 2407760 defendant Longdon William   593484 593484 Longdon, William, of Bere, parson & clerk 2
5192849 2413630 2413630 defendant Longdon William   593484 593484 Longdon, William, of Bere, parson & clerk 2
5409732 2477887 2477887 defendant Sterre John yeoman 593484 593484 Sterre, John, of Bere, yeoman 0
5423413 2481963 2481963 defendant Sterre John   593484 593484 Sterre, John, of Bere 0
5442720 2487734 2487734 defendant Sterre John yeoman 593484 593484 Sterre, John, of Bere, yeoman 0
5470333 2496050 2496050 plaintiff Gardyner John   593484 593484 Gardyner, John, of Bere 0
5516810 2510077 2510077 defendant Turbervyle Richard esq 593484 593484 Turbervyle, Richard, of Bere, esq 0
5516811 2510077 2510077 defendant Jurden John husbandman 593484 593484 Jurden, John, of Bere, husbandman 1
5579636 2528715 2528715 defendant Cobbe Richard tailor 593484 593484 Cobbe, Richard, of Bere, tailor 0
5625284 2551845 2551845 defendant Shepherd Peter husbandman 593484 593484 Shepherd, Peter, of Bere, husbandman 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);