names

32 rows where place_id = 697502

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4119986 2067435 2067435 defendant Palmer Thomas carpenter 697502 697502 Palmer, Thomas, of Castle Framlingham, carpenter 2
4128981 2070666 2070666 defendant Spalding Thomas butcher 697502 697502 Spalding, Thomas, of Castle Framlingham, butcher 0
4152449 2078968 2078968 defendant Spaldinge Thomas butcher 697502 697502 Spaldinge, Thomas, of Castle Framlingham, butcher 0
4159938 2081543 2081543 defendant Shymynge Nicholas yeoman 697502 697502 Shymynge, Nicholas, of Castle Framlingham, yeoman 1
4192746 2093023 2093023 defendant Stoffer William husbandman 697502 697502 Stoffer, William, of Castle Framlingham, husbandman 0
4204827 2097231 2097231 defendant Hayle William yeoman 697502 697502 Hayle, William, of Castle Framlingham, yeoman 0
4208880 2098652 2098652 defendant Palmer Thomas carpenter 697502 697502 Palmer, Thomas, of Castle Framlingham, carpenter 1
4219722 2102403 2102403 defendant Hellwys Robert yeoman 697502 697502 Hellwys, Robert, of Castle Framlingham, yeoman 0
4219723 2102403 2102403 defendant Hellwys Edmund   697502 697502 Hellwys, Edmund, of Castle Framlingham, yeoman, wheelwright, son of Robert 1
4219724 2102403 2102403 defendant Corker John gent 697502 697502 Corker, John, of Castle Framlingham, gent 2
4220213 2102573 2102573 defendant Darneford Thomas   697502 697502 Darneford, Thomas, of Castle Framlingham, woollen draper 0
4233813 2107351 2107351 defendant Bullerde John tailor 697502 697502 Bullerde, John, of Castle Framlingham, tailor 3
4242701 2110547 2110547 defendant Gayton Robert husbandman 697502 697502 Gayton, Robert, of Castle Framlingham, husbandman 3
4245839 2111587 2111587 defendant Hellwys Robert yeoman 697502 697502 Hellwys, Robert, of Castle Framlingham, yeoman 0
4249893 2112945 2112945 defendant Murrell William shoemaker 697502 697502 Murrell, William, of Castle Framlingham, shoemaker 1
4277270 2121981 2121981 defendant Botwright Thomas yeoman 697502 697502 Botwright, Thomas, of Castle Framlingham, yeoman 0
4277636 2122101 2122101 defendant Whitman Charles pewterer 697502 697502 Whitman, Charles, of Castle Framlingham, pewterer 0
4277637 2122101 2122101 defendant Crispe George (legal representative) 697502 697502 Crispe, George, of Castle Framlingham, clothworker, administrator of 1
4277638 2122101 2122101 defendant Girlinge Thomas butcher 697502 697502 Girlinge, Thomas, of Castle Framlingham, butcher 2
4284154 2124379 2124379 defendant Kinge Simon joiner 697502 697502 Kinge, Simon, of Castle Framlingham, joiner 0
4303258 2131268 2131268 defendant Cole Richard yeoman 697502 697502 Cole, Richard, of Castle Framlingham, yeoman 1
4308557 2133145 2133145 defendant Poope John yeoman 697502 697502 Poope, John, of Castle Framlingham, yeoman 0
4331144 2140716 2140716 defendant Smyth Anthony saddler 697502 697502 Smyth, Anthony, of Castle Framlingham, saddler 0
4346848 2146151 2146151 defendant Shemynge Nicholas yeoman 697502 697502 Shemynge, Nicholas, of Castle Framlingham, yeoman 0
4346850 2146152 2146152 defendant Ireland John yeoman 697502 697502 Ireland, John, of Castle Framlingham, yeoman 0
4347915 2146522 2146522 defendant Barnes William chapman 697502 697502 Barnes, William, of Castle Framlingham, chapman 2
4371490 2154857 2154857 defendant Colvile Thomas gent 697502 697502 Colvile, Thomas, of Castle Framlingham, gent 0
4385457 2159826 2159826 defendant Botrid Thomas yeoman 697502 697502 Botrid, Thomas, of Castle Framlingham, yeoman 0
4397683 2163803 2163803 defendant Whytman Charles pewterer 697502 697502 Whytman, Charles, of Castle Framlingham, pewterer 0
4398568 2164101 2164101 defendant Gyrlinge Robert butcher 697502 697502 Gyrlinge, Robert, of Castle Framlingham, butcher 1
4407538 2167086 2167086 defendant Pulham Robert yeoman 697502 697502 Pulham, Robert, of Castle Framlingham, yeoman 1
4412567 2168792 2168792 defendant Freman John weaver 697502 697502 Freman, John, of Castle Framlingham, weaver 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);