names

56 rows where place_id = 593236

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611005 1871120 1871120 defendant Middelton John husbandman 593236 593236 Middelton, John, of Bradwall, husbandman 0
3611006 1871120 1871120 defendant Middelton Thurstan husbandman 593236 593236 Middelton, Thurstan, of Bradwall, husbandman 1
3611007 1871120 1871120 defendant Middelton Ralph husbandman 593236 593236 Middelton, Ralph, of Bradwall, husbandman 2
3656052 1912145 1912145 defendant Catell Alexander husbandman 593236 593236 Catell, Alexander, of Bradwall, husbandman 0
4174905 2086688 2086688 defendant Newton Thomas laborer 593236 593236 Newton, Thomas, of Bradwall, laborer 1
4174906 2086688 2086688 defendant Moumford John laborer 593236 593236 Moumford, John, of Bradwall, laborer 2
4325559 2138923 2138923 defendant Marshall Humphrey yeoman 593236 593236 Marshall, Humphrey, of Bradwall, yeoman 0
4325560 2138923 2138923 defendant Middleton Richard yeoman 593236 593236 Middleton, Richard, of Bradwall, yeoman 1
4325562 2138923 2138923 defendant Middleton William yeoman 593236 593236 Middleton, William, of Bradwall, yeoman 3
4630044 2240313 2240313 defendant Burton John   593236 593236 Burton, John, of Bradwall 8
4687737 2261738 2261738 defendant Snede Richard husbandman 593236 593236 Snede, Richard, of Bradwall, husbandman 3
4690933 2262694 2262694 defendant Cok Richard yeoman & son of John Cok 593236 593236 Cok, Richard, of Bradwall, yeoman & son of John Cok 0
4774135 2287897 2287897 defendant Cok Richard yeoman 593236 593236 Cok, Richard, of Bradwall, yeoman 0
4776783 2288728 2288728 defendant Baumford Thomas husbandman 593236 593236 Baumford, Thomas, of Bradwall, husbandman 0
4806790 2298335 2298335 defendant atte Touneshende John yeoman 593236 593236 atte Touneshende, John, of Bradwall, yeoman 1
4913116 2330596 2330596 defendant Cook Ralph husbandman 593236 593236 Cook, Ralph, of Bradwall, husbandman 3
4941666 2339416 2339416 defendant Bradwall Thomas laborer 593236 593236 Bradwall, Thomas, of Bradwall, laborer 0
4941667 2339416 2339416 defendant Tounesend William laborer 593236 593236 Tounesend, William, of Bradwall, laborer 1
4944189 2340153 2340153 defendant Howe Roger husbandman 593236 593236 Howe, Roger, of Bradwall, husbandman 2
4944190 2340153 2340153 defendant Markham John miner 593236 593236 Markham, John, of Bradwall, miner 3
5029798 2365589 2365589 defendant Slak William yeoman 593236 593236 Slak, William, of Bradwall, yeoman 2
5029799 2365589 2365589 defendant Slak Thomas husbandman 593236 593236 Slak, Thomas, of Bradwall, husbandman 3
5037938 2367976 2367976 defendant Hall Thomas husbandman 593236 593236 Hall, Thomas, of Bradwall, husbandman 6
5047425 2370850 2370850 defendant Slak Thomas husbandman 593236 593236 Slak, Thomas, of Bradwall, husbandman 5
5054409 2372895 2372895 defendant Payn Ralph miner 593236 593236 Payn, Ralph, of Bradwall, miner 3
5061796 2375123 2375123 defendant Howe Roger yeoman 593236 593236 Howe, Roger, of Bradwall, yeoman 0
5327632 2453341 2453341 defendant Hall Thomas yeoman 593236 593236 Hall, Thomas, of Bradwall, yeoman 3
5327633 2453341 2453341 defendant Middelton Robert yeoman 593236 593236 Middelton, Robert, of Bradwall, yeoman 4
5327634 2453341 2453341 defendant Middelton John husbandman 593236 593236 Middelton, John, of Bradwall, husbandman 5
5327635 2453341 2453341 defendant Slakke Richard yeoman 593236 593236 Slakke, Richard, of Bradwall, yeoman 6
5327643 2453341 2453341 defendant Syward Nicholas yeoman 593236 593236 Syward, Nicholas, of Bradwall, yeoman 14
5327644 2453341 2453341 defendant Bradwall Thomas yeoman 593236 593236 Bradwall, Thomas, of Bradwall, yeoman 15
5327645 2453341 2453341 defendant Marshall Elias yeoman 593236 593236 Marshall, Elias, of Bradwall, yeoman 16
5327646 2453341 2453341 defendant Burton John husbandman 593236 593236 Burton, John, of Bradwall, husbandman 17
5327647 2453341 2453341 defendant Elotte William husbandman 593236 593236 Elotte, William, of Bradwall, husbandman 18
5327648 2453341 2453341 defendant Tounende William yeoman 593236 593236 Tounende, William, of Bradwall, yeoman 19
5327649 2453341 2453341 defendant Tounende Nicholas yeoman 593236 593236 Tounende, Nicholas, of Bradwall, yeoman 20
5327651 2453341 2453341 defendant Hawe Hugh husbandman 593236 593236 Hawe, Hugh, of Bradwall, husbandman 22
5327652 2453341 2453341 defendant Elotte Robert husbandman 593236 593236 Elotte, Robert, of Bradwall, husbandman 23
5327653 2453341 2453341 defendant Cokke John husbandman 593236 593236 Cokke, John, of Bradwall, husbandman 24
5327654 2453341 2453341 defendant Cokke Richard yeoman 593236 593236 Cokke, Richard, of Bradwall, yeoman 25
5327655 2453341 2453341 defendant Hawe Richard yeoman 593236 593236 Hawe, Richard, of Bradwall, yeoman 26
5327657 2453341 2453341 defendant Eyre Thurstan yeoman 593236 593236 Eyre, Thurstan, of Bradwall, yeoman 28
5327658 2453341 2453341 defendant Tasker Thomas husbandman 593236 593236 Tasker, Thomas, of Bradwall, husbandman 29
5327659 2453341 2453341 defendant Iryssh William husbandman 593236 593236 Iryssh, William, of Bradwall, husbandman 30
5327660 2453341 2453341 defendant Johnson Hugh yeoman 593236 593236 Johnson, Hugh, of Bradwall, yeoman 31
5327661 2453341 2453341 defendant Smyth William husbandman 593236 593236 Smyth, William, of Bradwall, husbandman 32
5327662 2453341 2453341 defendant Hawe Thomas yeoman 593236 593236 Hawe, Thomas, of Bradwall, yeoman 33
5327663 2453341 2453341 defendant Bradwall Hugh yeoman 593236 593236 Bradwall, Hugh, of Bradwall, yeoman 34
5327665 2453341 2453341 defendant Thomasson William husbandman 593236 593236 Thomasson, William, of Bradwall, husbandman 36
5338514 2456614 2456614 defendant Ayre Roger yeoman 593236 593236 Ayre, Roger, of Bradwall, yeoman 11
5346877 2459181 2459181 defendant Koo Richard yeoman 593236 593236 Koo, Richard, of Bradwall, yeoman 0
5406358 2476889 2476889 defendant Clerke John yeoman 593236 593236 Clerke, John, of Bradwall, yeoman 2
5446671 2488897 2488897 defendant Tymme Giles, sen husbandman 593236 593236 Tymme, Giles, sen, of Bradwall, husbandman 0
5458167 2492350 2492350 defendant Tunne Giles, sen husbandman 593236 593236 Tunne, Giles, sen, of Bradwall, husbandman 0
5561644 2523392 2523392 defendant Middilton John yeoman 593236 593236 Middilton, John, of Bradwall, yeoman 6

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