names

50 rows where place_id = 636669

✎ 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
3832030 1967915 1967915 defendant Clayton Edward yeoman 636669 636669 Clayton, Edward, of Balderton, yeoman 1
3845750 1972219 1972219 defendant Inkersall William yeoman 636669 636669 Inkersall, William, of Balderton, yeoman 0
3861494 1977306 1977306 defendant Inkersall William yeoman 636669 636669 Inkersall, William, of Balderton, yeoman 0
3861496 1977307 1977307 defendant Inkersall William yeoman 636669 636669 Inkersall, William, of Balderton, yeoman 0
3864779 1978416 1978416 defendant Nicholas John husbandman 636669 636669 Nicholas, John, of Balderton, husbandman 0
3864780 1978416 1978416 defendant Nycholas Roger husbandman 636669 636669 Nycholas, Roger, of Balderton, husbandman 1
3887001 1985916 1985916 defendant Alkoke William husbandman 636669 636669 Alkoke, William, of Balderton, husbandman 0
3914791 1995294 1995294 defendant Draper John laborer 636669 636669 Draper, John, of Balderton, laborer 1
3916772 1995977 1995977 defendant Draper John husbandman 636669 636669 Draper, John, of Balderton, husbandman 0
3927190 1999429 1999429 defendant Smyth Nicholas yeoman 636669 636669 Smyth, Nicholas, of Balderton, yeoman 0
3960339 2010713 2010713 defendant Tayllor Thomas smith 636669 636669 Tayllor, Thomas, of Balderton, smith 0
3993552 2022438 2022438 defendant Martyn William husbandman 636669 636669 Martyn, William, of Balderton, husbandman 0
3993554 2022439 2022439 defendant Newton Richard husbandman 636669 636669 Newton, Richard, of Balderton, husbandman 0
4009507 2028166 2028166 defendant Skrymshawe Edward husbandman 636669 636669 Skrymshawe, Edward, of Balderton, husbandman 0
4058409 2045393 2045393 defendant Newton Richard husbandman 636669 636669 Newton, Richard, of Balderton, husbandman 0
4071875 2050241 2050241 plaintiff Newton John husbandman 636669 636669 Newton, John, of Balderton, husbandman 0
4145541 2076595 2076595 defendant Haslambye Samuel yeoman 636669 636669 Haslambye, Samuel, of Balderton, yeoman 0
4153007 2079156 2079156 defendant Robynson John husbandman 636669 636669 Robynson, John, of Balderton, husbandman 0
4192287 2092863 2092863 defendant Squire John yeoman 636669 636669 Squire, John, of Balderton, yeoman 2
4275774 2121477 2121477 defendant Holcrofte Henry gent 636669 636669 Holcrofte, Henry, of Balderton, gent 0
4283367 2124089 2124089 defendant Foster Giles esq 636669 636669 Foster, Giles, of Balderton, esq 0
4294842 2128240 2128240 defendant Nicholas William yeoman 636669 636669 Nicholas, William, of Balderton, yeoman 0
4360983 2151101 2151101 defendant Adamson Charles husbandman 636669 636669 Adamson, Charles, of Balderton, husbandman 1
4396004 2163240 2163240 defendant Jenour George gent 636669 636669 Jenour, George, of Balderton, gent 0
4410644 2168152 2168152 defendant Smyth Anthony yeoman 636669 636669 Smyth, Anthony, of Balderton, yeoman 0
4410645 2168152 2168152 defendant Cawdre Richard husbandman 636669 636669 Cawdre, Richard, of Balderton, husbandman 1
4410646 2168152 2168152 defendant Marten William husbandman 636669 636669 Marten, William, of Balderton, husbandman 2
4410647 2168152 2168152 defendant Naler Thomas carpenter 636669 636669 Naler, Thomas, of Balderton, carpenter 3
4751679 2280980 2280980 defendant Gye Robert husbandman 636669 636669 Gye, Robert, of Balderton, husbandman 2
4755973 2282251 2282251 defendant Claypole Robert dyer 636669 636669 Claypole, Robert, of Balderton, dyer 1
4757627 2282763 2282763 defendant Gylian John husbandman 636669 636669 Gylian, John, of Balderton, husbandman 0
4757629 2282763 2282763 defendant Hogon Walter husbandman 636669 636669 Hogon, Walter, of Balderton, husbandman 2
4771802 2287157 2287157 defendant Broun Mathew husbandman 636669 636669 Broun, Mathew, of Balderton, husbandman 1
4778214 2289171 2289171 defendant Burne William husbandman 636669 636669 Burne, William, of Balderton, husbandman 0
4780250 2289823 2289823 defendant Gylian John husbandman 636669 636669 Gylian, John, of Balderton, husbandman 0
4871814 2318156 2318156 defendant Whytby William husbandman 636669 636669 Whytby, William, of Balderton, husbandman 3
4948211 2341414 2341414 defendant Burnell Hugh husbandman 636669 636669 Burnell, Hugh, of Balderton, husbandman 0
5057096 2373700 2373700 defendant Walker William husbandman 636669 636669 Walker, William, of Balderton, husbandman 1
5060519 2374725 2374725 defendant Dekon Robert chaplain 636669 636669 Dekon, Robert, of Balderton, chaplain 0
5083957 2381703 2381703 defendant Starky Miles husbandman 636669 636669 Starky, Miles, of Balderton, husbandman 0
5182961 2410763 2410763 defendant Walker William yeoman 636669 636669 Walker, William, of Balderton, yeoman 0
5225922 2423253 2423253 defendant Walker William husbandman 636669 636669 Walker, William, of Balderton, or of Knesall, husbandman 0
5228765 2424025 2424025 plaintiff White William   636669 636669 White, William, of Balderton 0
5231424 2424777 2424777 defendant Rande John husbandman 636669 636669 Rande, John, of Balderton, husbandman 0
5231425 2424777 2424777 defendant Rande William husbandman 636669 636669 Rande, William, of Balderton, husbandman 1
5257276 2432399 2432399 defendant Webster William husbandman 636669 636669 Webster, William, of Balderton, husbandman 1
5273070 2437198 2437198 defendant Henkys John yeoman 636669 636669 Henkys, John, of Balderton, yeoman 2
5506050 2506815 2506815 defendant Spaldeforth Roger husbandman 636669 636669 Spaldeforth, Roger, of Balderton, husbandman 0
5536217 2515821 2515821 defendant Clerke John husbandman 636669 636669 Clerke, John, of Balderton, husbandman 5
5628519 2552889 2552889 defendant Watson Robert husbandman 636669 636669 Watson, Robert, of Balderton, husbandman 3

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);