names

50 rows where place_id = 592136

✎ 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
3606694 1869768 1869768 defendant Savage William yeoman 592136 592136 Savage, William, of Sharnebroke, yeoman 0
3660804 1913644 1913644 plaintiff Hunt Lawrence gent 592136 592136 Hunt, Lawrence, of Sharnebroke, gent 0
3692056 1923685 1923685 defendant Bower Richard laborer 592136 592136 Bower, Richard, of Sharnebroke, laborer 0
3738273 1938185 1938185 defendant Gery William husbandman 592136 592136 Gery, William, of Sharnebroke, husbandman 0
3766376 1947138 1947138 defendant Hunt Henry gent 592136 592136 Hunt, Henry, of Sharnebroke, gent 3
3843622 1971538 1971538 plaintiff Cobbe William smith 592136 592136 Cobbe, William, of Sharnebroke, smith 0
3843623 1971538 1971538 defendant Calvard William gent 592136 592136 Calvard, William, of Sharnebroke, gent 0
3905190 1992000 1992000 defendant Parbery Henry miller 592136 592136 Parbery, Henry, of Sharnebroke, miller 1
4168988 2084647 2084647 defendant Woodham John butcher 592136 592136 Woodham, John, of Sharnebroke, butcher 1
4596970 2230295 2230295 defendant Smyth John   592136 592136 Smyth, John, of Sharnebroke 0
4596971 2230295 2230295 defendant Eve Roger   592136 592136 Eve, Roger, of Sharnebroke 1
4610038 2234225 2234225 defendant Smyth Robert   592136 592136 Smyth, Robert, of Sharnebroke 0
4735330 2276196 2276196 defendant Spaldewyk John clerk 592136 592136 Spaldewyk, John, of Sharnebroke, clerk 3
4744747 2278978 2278978 defendant Leche John husbandman 592136 592136 Leche, John, of Sharnebroke, husbandman 3
4744748 2278978 2278978 defendant Smyth John butcher 592136 592136 Smyth, John, of Sharnebroke, butcher 4
4777806 2289048 2289048 defendant Warde John yeoman 592136 592136 Warde, John, of Sharnebroke, yeoman 0
4784543 2291171 2291171 defendant Baker John dyer 592136 592136 Baker, John, of Sharnebroke, dyer 0
4788076 2292338 2292338 defendant Leche John husbandman 592136 592136 Leche, John, of Sharnebroke, husbandman 0
4795308 2294685 2294685 defendant Braunston Henry miller 592136 592136 Braunston, Henry, of Sharnebroke, miller 0
4800556 2296355 2296355 defendant Leche John husbandman 592136 592136 Leche, John, of Sharnebroke, husbandman 2
4815019 2300808 2300808 defendant Stalworth John smith 592136 592136 Stalworth, John, of Sharnebroke, smith 3
4845643 2310147 2310147 defendant Stalworth John smith 592136 592136 Stalworth, John, of Sharnebroke, smith 0
4851746 2311984 2311984 defendant Smyth John husbandman 592136 592136 Smyth, John, of Sharnebroke, husbandman 0
4852203 2312118 2312118 defendant Salter John   592136 592136 Salter, John, of Sharnebroke, shepherd 2
4852204 2312118 2312118 defendant Warde John husbandman 592136 592136 Warde, John, of Sharnebroke, husbandman 3
4852205 2312118 2312118 defendant Sompter William husbandman 592136 592136 Sompter, William, of Sharnebroke, husbandman 4
4859654 2314392 2314392 defendant Smyth John husbandman 592136 592136 Smyth, John, of Sharnebroke, husbandman 0
4894045 2324838 2324838 defendant Avon John husbandman 592136 592136 Avon, John, of Sharnebroke, husbandman 3
4931664 2336292 2336292 plaintiff Warde John (legal representative) 592136 592136 Warde, John, of Sharnebroke, executors of 0
4931668 2336292 2336292 defendant Barbour Simon husbandman 592136 592136 Barbour, Simon, of Sharnebroke, husbandman 1
4931669 2336292 2336292 defendant Sumpter William husbandman 592136 592136 Sumpter, William, of Sharnebroke, husbandman 2
4931670 2336292 2336292 defendant Daundely Robert husbandman 592136 592136 Daundely, Robert, of Sharnebroke, husbandman 3
4933795 2336949 2336949 defendant Savage William gent 592136 592136 Savage, William, of Sharnebroke, gent 0
4933796 2336949 2336949 defendant Heywode John gent 592136 592136 Heywode, John, of Sharnebroke, gent 1
4953320 2342957 2342957 defendant Styward William butcher 592136 592136 Styward, William, of Sharnebroke, butcher 0
4974802 2349434 2349434 defendant Styward William butcher 592136 592136 Styward, William, of Sharnebroke, butcher 3
5031397 2366040 2366040 defendant Bytheree William, senior yeoman 592136 592136 Bytheree, William, senior, of Sharnebroke, yeoman 0
5074316 2378814 2378814 defendant Smyth John, junior butcher 592136 592136 Smyth, John, junior, of Sharnebroke, butcher 0
5074318 2378815 2378815 defendant Warde William husbandman 592136 592136 Warde, William, of Sharnebroke, husbandman 0
5099471 2386282 2386282 defendant Smyth John butcher 592136 592136 Smyth, John, of Sharnebroke, butcher 1
5113873 2390447 2390447 defendant Warde John, junior husbandman 592136 592136 Warde, John, junior, of Sharnebroke, husbandman 1
5113874 2390447 2390447 defendant Warde John, senior husbandman 592136 592136 Warde, John, senior, of Sharnebroke, husbandman 2
5178840 2409538 2409538 defendant Basse John husbandman 592136 592136 Basse, John, of Sharnebroke, husbandman 1
5178841 2409538 2409538 defendant Warde William husbandman 592136 592136 Warde, William, of Sharnebroke, husbandman 2
5201629 2416243 2416243 defendant Basse John husbandman 592136 592136 Basse, John, of Sharnebroke, husbandman 1
5201630 2416243 2416243 defendant Warde William husbandman 592136 592136 Warde, William, of Sharnebroke, husbandman 2
5523706 2512244 2512244 plaintiff Gery William butcher 592136 592136 Gery, William, of Sharnebroke, butcher 0
5529880 2513851 2513851 defendant Barette John yeoman 592136 592136 Barette, John, of Sharnebroke, yeoman 0
5553163 2520965 2520965 defendant Gery William butcher 592136 592136 Gery, William, of Sharnebroke, butcher 0
5553164 2520965 2520965 defendant Gery Thomas husbandman 592136 592136 Gery, Thomas, of Sharnebroke, 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);