names

78 rows where place_id = 587149

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590599 1864703 1864703 defendant Braunche William gent 587149 587149 Braunche, William, of Fryskeney, gent 0
3626705 1903198 1903198 defendant Godfrey Thomas chaplain 587149 587149 Godfrey, Thomas, of Fryskeney, chaplain 0
3677682 1919065 1919065 defendant Kyme Thomas esq 587149 587149 Kyme, Thomas, of Fryskeney, esq 0
3705977 1928159 1928159 defendant Hobson William husbandman 587149 587149 Hobson, William, of Fryskeney, husbandman 0
3705978 1928159 1928159 defendant Stanes John husbandman 587149 587149 Stanes, John, of Fryskeney, husbandman 1
3732928 1936522 1936522 defendant Kyme Thomas gent 587149 587149 Kyme, Thomas, of Fryskeney, gent 0
3831086 1967607 1967607 defendant Wodrof William husbandman 587149 587149 Wodrof, William, of Fryskeney, husbandman 2
3836474 1969315 1969315 defendant Kyme Thomas, junior esq 587149 587149 Kyme, Thomas, junior, of Fryskeney, esq 0
3848371 1973067 1973067 defendant Goos Robert fisher 587149 587149 Goos, Robert, of Fryskeney, fisher 1
3852580 1974414 1974414 defendant Kyme Thomas esq 587149 587149 Kyme, Thomas, of Fryskeney, esq 0
3885732 1985482 1985482 defendant Cutt Robert husbandman 587149 587149 Cutt, Robert, of Fryskeney, husbandman 0
3893517 1988058 1988058 defendant Warde John husbandman 587149 587149 Warde, John, of Fryskeney, husbandman 0
3964761 2012281 2012281 defendant Coxson John husbandman 587149 587149 Coxson, John, of Fryskeney, husbandman 1
3965258 2012463 2012463 defendant Hall Thomas yeoman 587149 587149 Hall, Thomas, of Fryskeney, yeoman 0
4595422 2229824 2229824 defendant Michell William   587149 587149 Michell, William, of Fryskeney 0
4658142 2248424 2248424 defendant Campe Walter husbandman 587149 587149 Campe, Walter, of Fryskeney, husbandman 0
4665960 2250828 2250828 plaintiff Hudson John   587149 587149 Hudson, John, of Fryskeney 0
4667565 2255573 2255573 defendant Skynner John husbandman 587149 587149 Skynner, John, of Fryskeney, husbandman 6
4718144 2271012 2271012 defendant Kyme John gent 587149 587149 Kyme, John, of Fryskeney, gent 3
4718145 2271012 2271012 defendant Brit Richard chaplain 587149 587149 Brit, Richard, of Fryskeney, chaplain 4
4718146 2271012 2271012 defendant Kelsey William chaplain 587149 587149 Kelsey, William, of Fryskeney, chaplain 5
4788947 2292597 2292597 plaintiff Hobson John, senior   587149 587149 Hobson, John, senior, of Fryskeney 0
4813624 2300366 2300366 defendant Busshe Thomas husbandman 587149 587149 Busshe, Thomas, of Fryskeney, husbandman 0
4814217 2300551 2300551 defendant Peresson John husbandman 587149 587149 Peresson, John, of Fryskeney, husbandman 1
4826347 2304278 2304278 defendant Edward Richard husbandman 587149 587149 Edward, Richard, of Fryskeney, husbandman 0
4867041 2316656 2316656 defendant Hochonnes Walter husbandman 587149 587149 Hochonnes, Walter, of Fryskeney, husbandman 0
4869026 2317283 2317283 defendant Tarsell Stephen husbandman 587149 587149 Tarsell, Stephen, of Fryskeney, husbandman 0
4869171 2317337 2317337 plaintiff Kyme John   587149 587149 Kyme, John, of Fryskeney 0
4869175 2317338 2317338 plaintiff Kyme John   587149 587149 Kyme, John, of Fryskeney 0
4869182 2317339 2317339 plaintiff Kyme John   587149 587149 Kyme, John, of Fryskeney 0
4886105 2322513 2322513 plaintiff Michell William (legal representative) 587149 587149 Michell, William, of Fryskeney, executors of 0
4886107 2322513 2322513 plaintiff Brette Richard chaplain 587149 587149 Brette, Richard, of Fryskeney, chaplain 2
4887816 2323018 2323018 plaintiff Dymmok John   587149 587149 Dymmok, John, of Fryskeney 0
4897080 2325742 2325742 defendant Jurdon John cooper 587149 587149 Jurdon, John, of Fryskeney, cooper 0
4913946 2330871 2330871 defendant Edworth Richard husbandman 587149 587149 Edworth, Richard, of Fryskeney, husbandman 0
4913947 2330871 2330871 defendant Bole John husbandman 587149 587149 Bole, John, of Fryskeney, husbandman 1
4915909 2331471 2331471 plaintiff Dymmok John   587149 587149 Dymmok, John, of Fryskeney 0
4915916 2331473 2331473 defendant Edwroth Richard yeoman 587149 587149 Edwroth, Richard, of Fryskeney, yeoman 0
4916825 2331767 2331767 defendant Bole John husbandman 587149 587149 Bole, John, of Fryskeney, husbandman 0
4934416 2337154 2337154 defendant Bole John husbandman 587149 587149 Bole, John, of Fryskeney, husbandman 1
4939967 2338888 2338888 defendant Bole John husbandman 587149 587149 Bole, John, of Fryskeney, husbandman 0
4939968 2338888 2338888 defendant Pereson John husbandman 587149 587149 Pereson, John, of Fryskeney, husbandman 1
4939969 2338889 2338889 plaintiff Cutt John   587149 587149 Cutt, John, of Fryskeney 0
4942971 2339778 2339778 defendant Bole John husbandman 587149 587149 Bole, John, of Fryskeney, husbandman 0
4967335 2347174 2347174 defendant Smyth Ranulph husbandman 587149 587149 Smyth, Ranulph, of Fryskeney, husbandman 3
4973207 2348922 2348922 defendant Bole John fleshewer or butcher 587149 587149 Bole, John, of Fryskeney, fleshewer or butcher 2
4973671 2349077 2349077 defendant Boole John husbandman 587149 587149 Boole, John, of Fryskeney, husbandman 0
4978793 2350608 2350608 defendant Kyme Thomas   587149 587149 Kyme, Thomas, of Fryskeney 0
4998831 2356536 2356536 defendant Hurry John laborer 587149 587149 Hurry, John, of Fryskeney, laborer 1
4998848 2356539 2356539 defendant Gelyot William yeoman 587149 587149 Gelyot, William, of Fryskeney, yeoman 2
4998854 2356539 2356539 defendant Bret Simon husbandman 587149 587149 Bret, Simon, of Fryskeney, husbandman 8
4999215 2356637 2356637 defendant Cok John yeoman 587149 587149 Cok, John, of Fryskeney, yeoman 2
5012678 2360546 2360546 defendant Edworth Richard (legal representative) 587149 587149 Edworth, Richard, of Fryskeney, administratrix of 0
5025863 2364466 2364466 plaintiff Kyme Thomas   587149 587149 Kyme, Thomas, of Fryskeney 0
5025882 2364467 2364467 plaintiff Kyme Thomas esq 587149 587149 Kyme, Thomas, of Fryskeney, esq 0
5025886 2364468 2364468 plaintiff Kyme Thomas esq 587149 587149 Kyme, Thomas, of Fryskeney, esq 0
5026218 2364561 2364561 defendant Edworth Richard (legal representative) 587149 587149 Edworth, Richard, of Fryskeney, administratrix of 0
5027908 2365041 2365041 plaintiff Kyme Thomas esq 587149 587149 Kyme, Thomas, of Fryskeney, esq 1
5057349 2373765 2373765 defendant Raven William husbandman 587149 587149 Raven, William, of Fryskeney, husbandman 0
5057350 2373765 2373765 defendant Danson or Dauson John husbandman 587149 587149 Danson or Dauson, John, of Fryskeney, husbandman 1
5058376 2374052 2374052 defendant Gyllyot William husbandman 587149 587149 Gyllyot, William, of Fryskeney, husbandman 0
5060752 2374796 2374796 defendant Hode Hugh husbandman 587149 587149 Hode, Hugh, of Fryskeney, husbandman 0
5063433 2375589 2375589 defendant Allotson Thomas husbandman 587149 587149 Allotson, Thomas, of Fryskeney, husbandman 0
5071888 2378087 2378087 plaintiff Straunge John   587149 587149 Straunge, John, of Fryskeney 0
5081650 2381019 2381019 defendant Boole John butcher 587149 587149 Boole, John, of Fryskeney, butcher 0
5082882 2381383 2381383 defendant Kyme Thomas esq 587149 587149 Kyme, Thomas, of Fryskeney, esq 4
5132309 2395947 2395947 defendant Raven William husbandman 587149 587149 Raven, William, of Fryskeney, husbandman 1
5179672 2409792 2409792 defendant Clay Robert   587149 587149 Clay, Robert, of Fryskeney, vicar 0
5226763 2423495 2423495 plaintiff Straunge Thomas   587149 587149 Straunge, Thomas, of Fryskeney, administrators of 0
5287758 2441443 2441443 defendant Gilliot William husbandman 587149 587149 Gilliot, William, of Fryskeney, husbandman 3
5312955 2448906 2448906 defendant Kyme Thomas   587149 587149 Kyme, Thomas, of Fryskeney 0
5316792 2450108 2450108 defendant Anatson Robert laborer 587149 587149 Anatson, Robert, of Fryskeney, laborer 0
5320769 2451302 2451302 defendant Cok William husbandman 587149 587149 Cok, William, of Fryskeney, husbandman 1
5355827 2461897 2461897 plaintiff Kyme Thomas esq 587149 587149 Kyme, Thomas, of Fryskeney, esq 0
5378061 2468717 2468717 defendant Dandyson John husbandman 587149 587149 Dandyson, John, of Fryskeney, husbandman 0
5460361 2493038 2493038 defendant Dymmok John esq 587149 587149 Dymmok, John, of Fryskeney, esq 0
5469656 2495849 2495849 plaintiff Dymok John gent 587149 587149 Dymok, John, of Fryskeney, gent 0
5471981 2496578 2496578 defendant Dymmok John esq 587149 587149 Dymmok, John, of Fryskeney, esq 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);