names

63 rows where place_id = 614808

✎ 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
3621403 1874236 1874236 plaintiff Nesshefeld Roger   614808 614808 Nesshefeld, Roger, of Feldallyng, yeoman, exutors of 0
3705641 1928045 1928045 defendant Lowth William   614808 614808 Lowth, William, of Feldallyng 1
3706259 1928244 1928244 defendant Cake Robert husbandman 614808 614808 Cake, Robert, of Feldallyng, husbandman 3
3718167 1931968 1931968 defendant Nytynghale Robert chaplain 614808 614808 Nytynghale, Robert, of Feldallyng, chaplain 1
3720666 1932752 1932752 defendant Lowse William husbandman 614808 614808 Lowse, William, of Feldallyng, husbandman 1
3720669 1932753 1932753 defendant Lowse William husbandman 614808 614808 Lowse, William, of Feldallyng, husbandman 1
3723294 1933558 1933558 defendant Lowse William yeoman 614808 614808 Lowse, William, of Feldallyng, yeoman 1
3762764 1945992 1945992 defendant Lowse William yeoman 614808 614808 Lowse, William, of Feldallyng, yeoman 1
3764811 1946661 1946661 defendant Lowce or Lowoe William husbandman 614808 614808 Lowce or Lowoe, William, of Feldallyng, husbandman 1
3764820 1946664 1946664 defendant Lowse William husbandman 614808 614808 Lowse, William, of Feldallyng, husbandman 1
3804818 1959449 1959449 defendant Plane Thomas yeoman 614808 614808 Plane, Thomas, of Feldallyng, yeoman 2
3805647 1959710 1959710 defendant Horneby Robert clerk 614808 614808 Horneby, Robert, of Feldallyng, clerk 0
3846552 1972479 1972479 defendant Lowse William husbandman 614808 614808 Lowse, William, of Feldallyng, husbandman 0
3850929 1973883 1973883 plaintiff Nicholas William   614808 614808 Nicholas, William, of Feldallyng 0
3870469 1980364 1980364 defendant Lose William husbandman 614808 614808 Lose, William, of Feldallyng, husbandman 1
3884543 1985104 1985104 defendant Lowse Silvester husbandman 614808 614808 : Lowse, Silvester, of Feldallyng, husbandman 2
3897627 1989421 1989421 defendant Castor John husbandman 614808 614808 Castor, John, of Feldallyng, husbandman 0
3919197 1996747 1996747 defendant Borne John yeoman 614808 614808 Borne, John, of Feldallyng, yeoman 0
3956465 2009325 2009325 defendant Tuddenham Henry clerk 614808 614808 Tuddenham, Henry, of Feldallyng, clerk 0
3965703 2012620 2012620 defendant Nycholas Thomas yeoman 614808 614808 Nycholas, Thomas, of Feldallyng, yeoman 3
3968154 2013489 2013489 plaintiff Caster John yeoman 614808 614808 Caster, John, of Feldallyng, yeoman 0
3994654 2022840 2022840 defendant Bourne James gent 614808 614808 Bourne, James, of Feldallyng, gent 0
4027335 2034425 2034425 defendant Bourne James gent 614808 614808 Bourne, James, of Feldallyng, gent 0
4105737 2062340 2062340 defendant Stutevill Charles gent 614808 614808 Stutevill, Charles, of Feldallyng, gent 0
4150954 2078463 2078463 defendant Goose John husbandman 614808 614808 Goose, John, of Feldallyng, husbandman 0
4738365 2277095 2277095 defendant Waryn Gilger yeoman 614808 614808 Waryn, Gilger, of Feldallyng, yeoman 1
4748869 2280158 2280158 defendant Greve William husbandman 614808 614808 Greve, William, of Feldallyng, husbandman 0
4874048 2318824 2318824 defendant Waryn Gilbert (legal representative) 614808 614808 Waryn, Gilbert, of Feldallyng, executors of 0
4874049 2318824 2318824 defendant Nicolas William chaplain 614808 614808 (Nicolas, William, of Feldallyng, chaplain 1
4874050 2318824 2318824 defendant Bettys William husbandman 614808 614808 Bettys, William, of Feldallyng, husbandman 2
4874051 2318824 2318824 defendant Smoewlyng John husbandman 614808 614808 Smoewlyng, John, of Feldallyng, husbandman 3
4889779 2323596 2323596 defendant Cake Thomas husbandman 614808 614808 Cake, Thomas, of Feldallyng, husbandman 0
4951162 2342328 2342328 defendant Smonlyng or Sivonlyng John husbandman 614808 614808 together with Smonlyng or Sivonlyng, John, of Feldallyng, husbandman 3
4964939 2346428 2346428 defendant Grene John husbandman 614808 614808 Grene, John, of Feldallyng, husbandman 1
4975332 2349579 2349579 defendant Kake Thomas yeoman 614808 614808 Kake, Thomas, of Feldallyng, yeoman 2
5224206 2422749 2422749 defendant Hopper William husbandman 614808 614808 Hopper, William, of Feldallyng, husbandman 2
5255295 2431773 2431773 defendant Scot or Stot John husbandman 614808 614808 Scot or Stot, John, of Feldallyng, husbandman 0
5273098 2437205 2437205 defendant Nicolas Thomas yeoman 614808 614808 Nicolas, Thomas, of Feldallyng, yeoman 1
5273826 2437422 2437422 defendant Bunwell John husbandman 614808 614808 Bunwell, John, of Feldallyng, husbandman 0
5277134 2438398 2438398 defendant Hert John weaver 614808 614808 Hert, John, of Feldallyng, weaver 1
5277135 2438398 2438398 defendant Smyth Thomas smith 614808 614808 Smyth, Thomas, of Feldallyng, smith 2
5278432 2438798 2438798 defendant Sadde Thomas   614808 614808 Sadde, Thomas, of Feldallyng, mason 3
5286602 2441092 2441092 defendant Perot Thomas yeoman 614808 614808 Perot, Thomas, of Feldallyng, yeoman 0
5290315 2442174 2442174 defendant Bunwell John husbandman 614808 614808 Bunwell, John, of Feldallyng, husbandman 0
5296771 2444044 2444044 defendant Perot John yeoman 614808 614808 Perot, John, of Feldallyng, yeoman 1
5303113 2445920 2445920 defendant Lo_ Robert husbandman 614808 614808 Lo_, Robert, of Feldallyng, husbandman 2
5306759 2447015 2447015 defendant Bolton Gilbert clerk 614808 614808 Bolton, Gilbert, of Feldallyng, clerk 0
5306760 2447015 2447015 defendant Smolyng Robert, sen yeoman 614808 614808 Smolyng, Robert, sen, of Feldallyng, yeoman 1
5306857 2447049 2447049 plaintiff Nicolas John   614808 614808 Nicolas, John, of Feldallyng 1
5307804 2447350 2447350 defendant Bond Robert, sen husbandman 614808 614808 Bond, Robert, sen, of Feldallyng, husbandman 0
5307806 2447350 2447350 defendant Grene William yeoman 614808 614808 Grene, William, of Feldallyng, yeoman 2
5314566 2449389 2449389 plaintiff Cake Nicholas   614808 614808 Cake, Nicholas, of Feldallyng 0
5335816 2455776 2455776 defendant Perot Thomas yeoman 614808 614808 Perot, Thomas, of Feldallyng, yeoman 4
5341042 2457399 2457399 defendant Yareham Robert carpenter 614808 614808 Yareham, Robert, of Feldallyng, carpenter 0
5422929 2481813 2481813 defendant Sadde Thomas   614808 614808 Sadde, Thomas, of Feldallyng, mason, on his own account 0
5433651 2485031 2485031 defendant Plane John husbandman 614808 614808 Plane, John, of Feldallyng, husbandman 0
5473388 2497002 2497002 defendant Plane John yeoman 614808 614808 Plane, John, of Feldallyng, yeoman 0
5482408 2499679 2499679 defendant Plane John yeoman 614808 614808 Plane, John, of Feldallyng, yeoman 0
5513833 2509182 2509182 plaintiff Plane John   614808 614808 Plane, John, of Feldallyng 0
5513838 2509182 2509182 defendant Yarham Robert carpenter 614808 614808 Yarham, Robert, of Feldallyng, carpenter 4
5571660 2526265 2526265 plaintiff Lose Robert (legal representative) 614808 614808 Lose, Robert, of Feldallyng, executrix of 0
5586574 2530837 2530837 plaintiff Lose Robert   614808 614808 Lose, Robert, of Feldallyng 0
5620840 2550388 2550388 defendant Gibbes William   614808 614808 Gibbes, William, of Feldallyng 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);