Lotus Domino Designer 8.5.x: LotusScript training

Duration:
Cost:
$1,325.00
Hours:
- Eastern

Course Overview

LotusScript is a BASIC derivative that uses many of the same statements and function names, so most developers will find it easy to understand and use without too much relearning. While this course teaches the basics of LotusScript, its primary emphasis is not on the language itself, but rather on how to use it to operate on Notes database, view, document, field, and ACL objects. With this knowledge, you will be able to develop powerful custom applications and extend the standard templates such as Mail or Discussion.

Live Online Schedule

Tap here to learn how our online classes work.

Live Onsite Training

Do you have five (5) or more people needing this class and want us to deliver it at your location?

Prerequisites

This course is designed for Notes programmers well versed in using Domino Designer 8.5.x. It assumes that you have: extensive experience using Notes 8.5.x thorough knowledge of the Domino Designer 8.5.x development environment, including Form and View design mastered the concepts covered in the Domino Designer: Classic Notes Applications course. The course does not review any aspects of the non-LotusScript specific development environment such as how to design forms or views. Though not required, experience in any event-driven or structured programming language is helpful in understanding LotusScript. If you have used LotusScript in other Lotus applications or have built applications using Microsoft® Visual Basic™, you will find that this course won't be repetitive as it focuses mostly on Notes objects.

Course Outline

  • Topic 1: LotusScript in Notes and Domino
    • What is LotusScript?
    • Advantages of LotusScript for Notes/Domino
    • When to use LotusScript
    • Where the code runs
    • LotusScript respects security
    • What LotusScript cannot do
    • Limits and performance
    • Other resources
  • Topic 2: Lotus Notes Event Handlers
    • Event-driven language
    • Enter LotusScript code using classic LotusScript Editor
    • Automatic code completion
    • Programmers Pane properties
    • Print code
    • Syntax errors
    • Compile and test the code
    • Exercise: Create button event script
    • Eclipse-based LotusScript Editor
    • What is the sequence of events?
    • Exercise: Experience the event model
    • What happened? Create document event handlers
    • Query what? Post what?
    • Recalculate document event
    • Save document event
    • Close document event
    • Switch modes events
    • Read document events
    • Agent events
    • Database events
    • View events
    • Field events
  • Topic 3: Debugging
    • Script errors
    • Script Debugger
    • Find errors
    • Debugger buttons
    • Debugger tabs
    • Exercise: Use the Debugger
    • Exercise: Breakpoints
    • Persistent breakpoints
    • Debugging with Msgbox and Print
  • Topic 4: Language Fundamentals
    • Basic language rules
    • Remark code
    • Variables
    • Declare variables
    • Advantages of explicit declaration
    • Constants
    • Statements and functions
    • MessageBox parameters and return values
    • How Designer Help helps
    • InputBox
    • Exercise: Experience LotusScript functions
    • String functions
    • Math functions
    • Date functions
    • Data type conversion
    • Boolean operators
    • Global variables and scope
    • Exercise: Global variables
    • Code branching based on platform
  • Topic 5: Program Control Structures
    • Program structure
    • Experience control structures
    • Branching structures
    • Exercise: Branching structures
    • Looping structures
    • Looping performance
    • Code benchmarking
    • Exercise: Looping
    • How to exit a structure
    • Break out of an endless loop
    • Exercise: Exit a structure
  • Topic 6: User Input Validation and Error Handling
    • Check for empty variable
    • Failure to exit loop
    • Check data type
    • Other data type tests
    • Exercise: User input validation
    • Error handler
    • Resume after error
    • Goto after error
    • Resume 0
    • Specific error number handling
    • Reverse engineer Err codes
    • Error cases
    • Exercise: Error handling
    • Multiple error handlers
    • Error handlers and the Debugger
  • Topic 7: Domino Object Model
    • What is an object?
    • Object class properties and methods
    • Domino Object Model
    • Back-end vs. Front-end classes
    • Back-end object classes
    • Front-end object classes
    • How Designer Help helps
  • Topic 8: Notes Object Instantiation
    • Object instantiation steps
    • How to instantiate an object
    • Containment hierarchy/sequence
    • Object reference variables
    • Best practice: Use generic object names
    • Access current database using back-end methods
    • Best practice: Use constants when practical
    • Use Domino Designer Help
    • Exercise: Object containers
    • Access other databases using back-end methods
    • Access other database on server
    • Exercise: Instantiate object in another database
    • Best practice: Public declarations of Notes objects
    • Notes object properties
    • Read object property
    • Set object property
    • Chain/pipe references
    • "With" statement
    • Notes object methods
    • Run Notes object methods
    • Three types of methods
    • Exercise: Open method
    • LotusScript is not a keystroke macro language
    • Interact with users via front-end methods
    • Exercise: Open database for user
    • Delete object reference
  • Topic 9: NotesSession Object Operations
    • Session properties
    • NotesName object class
    • NOTES.INI access
    • Data type assignment from environment
    • Exercise: Set environment
    • Environ$ function
  • Topic 10: NotesDatabase Object Operations
    • Paths to instantiate NotesDatabase
    • Select and open database
    • Create a new NotesDatabase object
    • Is the database really open?
    • Exercise: This database Info
    • Exercise: Parts database Info
    • Iterate notes\data folder to look for a database
    • NotesReplication class
    • Exercise: NotesReplication class
    • Open database for user in UI
    • Open a database by property
    • Error handling when opening databases
    • Exercise: Find database
    • Create non-replica database copy
    • Who can create a database?
    • Copy documents to new database
    • Exercise: Database Copy
    • Error handler review
    • Create replica copy
    • New database from design template
    • ACL of new database from CreateFromTemplate
    • Delete database
    • Case Study
  • Topic 11: NotesDocument Object Operations
    • New document (back-end)
    • Security issues with back-end methods
    • Document properties
    • Exercise: Create Document (back-end)
    • New document using Form (front-end)
    • Security issues with front-end methods
    • Exercise: Create NotesUIDocument object
  • Topic 12: NotesItem Object Operations
    • Create a new item Option 1: Extended class syntax
    • Data type of a new item
    • Create a new item Option 2: NotesItem object New method
    • Item properties you can set
    • Create a new item Option 3: Document object method
    • Create a new item Option 4: AppendItemValue method
    • Read item values Option 1: Extended class syntax
    • Read item values Option 2: NotesItem object Values property
    • Read item values Option 3: Use GetItemValue method
    • Modify existing item values
    • Best practice: Be sure an item exists before using it
    • Access system fields
    • Read all items
    • Remove item
    • Exercise: Manipulate NotesItem objects
    • Challenge Exercise I: System Inventory
    • Objects required for Challenge Exercise
    • Pseudocode for Challenge Exercise
  • Topic 13: UI Object Classes
    • NotesUIWorkspace object
    • Close method
    • NotesUIDocument object
    • Instantiating the current UI document object
    • Front-end UI methods
    • Back-end to front-end interaction
    • Example of back-end to front-end interaction
    • NotesUIDocument limitations
    • Using the "Source" object reference variable
    • Instantiating container object
    • Exercise: Flip-Flop via back-end methods
    • Exercise: Flip-Flop via front-end methods
    • NotesUIView object
    • Refresh a View
  • Topic 14: Notes Data Validation
    • Form translation and validation
    • Check empty object
    • Example: Check empty object
    • Check for empty item (Field)
    • Example: Check for empty item (Field entry)
    • Accessing fields in a Form
    • Field focus
    • Simple Field validation
    • Exercise: Item validation
    • Compute with Form
    • Continue variable
    • Example 1: Set Continue to stop a Form from closing
    • Example 2: Set Continue to require Action Button clicks
    • Example 3: Set Continue to stop deleting documents from a folder
    • Example 4: Set Continue to stop users from pasting documents
  • Topic 15: Multi-Value Items and Arrays
    • Array basics
    • Declare a static array
    • Assign values to an array
    • Read single array element value
    • Determine the number of elements in an array
    • Iteratively read array elements
    • Examples of object properties returning an array of values
    • Test if array is valid and not empty
    • Find an array element
    • Replace values in an array
    • Replace
    • Remove blank elements
    • ArrayUnique
    • Split
    • Join/Implode
    • Dynamically sized array
    • Create copy of an array
    • Erase array values
    • Exercise: Dynamic array
    • Append one array to another array
    • Multi- dimension arrays
    • Items and multi-value Fields
    • Variable assignment
    • Testing equivalence
    • Read an array of strings or array of objects?
    • Get multi-value Field in current document
    • Set multi-value Field in current document
    • Append value to existing multi-value Field
    • Exercise: Translate a multi-value Field
    • More on "Item" versus "Field"
    • Sort array
    • Challenge Exercise II: System inventory
    • Arrays and performance
    • Lists
    • User-defined data type
  • Topic 16: Date-Time Operations
    • How date/time is handled
    • Date and time in LotusScript
    • NotesDateTime object
    • Date/Time parameter format
    • NotesInternational object
  • Topic 17: RichTextItem Object Operations
    • Rich Text programmatic issues
    • Instantiate NotesRichTextItem object
    • Accessing existing NotesRichTextItem objects
    • Things you can add to Rich Text item
    • Append text
    • Append spacing
    • Append character styles
    • Best practice: Style arrays and subs
    • Append doclink
    • Exercise: Formatted Rich Text
    • Append file attachment
    • Detach attachment
    • Append another NotesRichTextItem
    • Abstract text
    • Navigate through the elements in a Rich Text item
    • Insert object into existing Rich Text
    • Example: Append and populate table
    • Reopen document to show Rich Text
    • NotesUIDocument techniques to work with Rich Text Field
    • Validate Rich Text entry
    • NotesRichTextItem object Update and Compact methods
    • Challenge Exercise III: System inventory
    • RTF versus MIME
  • Topic 18: Collection of Document Objects
    • Work on existing document(s)
    • NotesDocumentCollection object
    • Security issues
    • Shifting collections and error trapping
    • GetNextDocument syntax
    • Exercise: Loop through a collection
    • Solution: Loop through a collection
    • Create an empty collection
    • Add NotesDocument object to a collection
    • Remove NotesDocument object from a collection
    • Manipulate a collection
    • Batch changes to documents in a collection
    • Security is enforced with StampAll and RemoveAll
    • Sort a collection
    • Build a collection from Note objects
    • Collections and performance
  • Topic 19: View-Based Document Object Collections
    • NotesView object
    • Exercise: Loop through NotesView
    • Solution: Loop through NotesView
    • Resort the NotesView collection
    • NotesDocument object ColumnValues property
    • Primary key and View concerns
    • Get a document or document collection by View key
    • Example: Build a collection by View key
    • Process descendant documents
    • Iterate all levels of a document hierarchy
    • Sibling documents
    • Access a documents parent document
    • NotesViewEntryCollection object
    • EntryCount property
    • GetEntryByKey and GetAllEntriesByKey
    • NotesViewEntry and NotesDocument objects
    • Exercise: Status summary
    • Solution: Status summary
    • NotesViewNavigator object
    • Other ways to create a NotesViewNavigator
    • Example: CreateViewNavFromDescendants
  • Topic 20: Search-Based Document Collections
    • Collection from GetModifiedDocuments method
    • Create collection using Full Text Search
    • The Full Text Search query
    • Full Text Search using [FIELD]
    • Full Text Search for special items
    • Full Text Search options
    • Use the Full Text Search results
    • About the accuracy of Full Text Search
    • Refine an existing collection using FTSearch method
    • Exercise: FTSearch Summary
    • Solution: FTSearch summary
    • Create collection using Search method
    • Change a View Selection Formula
    • Exercise: Search summary
    • Solution: Search summary
    • Search method performance
    • Switch search methods on-the-fly
    • Domain Search
    • Code the FTDomainSearch method
  • Topic 21: Unprocessed, Selected, Unread Documents
    • Unprocessed documents
    • Unprocessed documents and user interaction
    • Agents and unprocessed documents
    • Unprocessed flag and Agents
    • Unprocessed search accuracy
    • Exercise: Unprocessed documents
    • Documents highlighted and/or selected in a View
    • "Source" and Database and View event handlers
    • Unread documents
  • Topic 22: Existing Document Operations
    • How to instantiate an existing NotesDocument object
    • Make a copy of the current document
    • Delete a document
    • Remove documents from the database
    • Security issues
    • Exercise: Archive selected documents
    • Test for locked document
    • Lock document
    • Does the document really need to be saved?
    • Soft deletions
    • Delete document open in Read mode
    • IsValid document? IsDeleted document?
    • Open user-selected document
    • Put document in Folder (back-end)
    • Put document in Folder (front-end)
    • Exercise: Put document(s) in Folder
    • Remove document(s) from Folder
    • Remove all Folders
    • Remove only personal Folders
    • Make Response document
  • Topic 23: Newsletter Object
    • NotesNewsletter object
    • Create newsletter
    • Exercise: Newsletter report
    • Case study: Custom search Form
    • Optional exercise: Order report
    • FormatDocument method
  • Topic 24: Mail Messages
    • Send document
    • Example Agent
    • Send method parameters
    • Source database
    • Read the Directory for user mail information
    • NotesDirectoryNavigator
    • Change the apparent sender name from Notes
    • Change the apparent sender name from an Agent
    • Prevent Agent mail "ping-pong"
    • Exercise: Send mal message
    • Optional properties and Fields
    • Exercise: Status Checker Agent
    • Solution: Status Checker Agent
    • Challenge Exercise IV: System inventory
    • Programmatically send Sametime instant messages
  • Topic 25: Evaluate @Functions
    • Why evaluate @Functions in LotusScript?
    • Which @Functions cannot be used?
    • Evaluate syntax
    • Examples
    • @Functions outside of object context
    • Sum an array
    • Lookups
    • Exercise: Using @Functions
    • Performance implications
  • Topic 26: Dialog Boxes
    • OpenFileDialog
    • SaveFileDialog
    • Prompt
    • Remove Docs from Folder using Prompt
    • Choose Database dialog box
    • PickListCollection
    • PickListStrings
    • Exercise: PickListStrings
    • Free Time dialogs
    • Notes Folder dialog
    • DialogBox
    • From where you can call the DialogBox method
    • Display status information to user
    • Case study: Bring the data here
  • Topic 27: Database Access Control List
    • User name review
    • Best practices
    • Minimum database access requirements
    • Find a known ACL entry level
    • ACL level constants
    • Iterate ACL entries
    • Other ACL permissions
    • Resolve Group or Organization wildcard name
    • Why control the ACL with LotusScript?
    • Add an ACL entry
    • -Default- special handling
    • Change the level of an entry
    • Rename an entry
    • Delete an entry
    • Exercise: ACL control
    • Set permissions
    • Set entry type
    • Add a Role
    • Associate an entry with a Role
    • Role resolution
    • Disassociate entry from Role
    • Rename Role
    • Remove a Role
    • ACL and replication
    • ACL, your server administrator, and company policy
    • Groups in the ACL
  • Topic 28: Profile Documents
    • Examples of Profile documents
    • The nature of Profile documents
    • Profile document security and replication
    • Create Profile document
    • Back-end method to create and access Profile document
    • Read Profile document Fields
    • List all Profile documents
    • Exercise: Profile document to store DDLS8 Parts server and filepath
    • Delete Profile document
    • Profile Document Management tool
    • Technotes related to Profile documents
  • Topic 29: Custom Procedures and Script Libraries
    • Advantages of using procedures
    • How/where to define procedures
    • Function procedures
    • Call a function
    • Single function argument
    • Pass an array as an argument
    • Multiple function arguments
    • Example: ConvertTemp function
    • Example: ReplaceSubstring function
    • Exercise: Value translation
    • Exit a procedure
    • Sub procedures
    • Example: Sub procedure
    • Pass argument by reference
    • Pass argument by value
    • Create a LotusScript Library
    • Use "LibraryName" statement in Options
    • Exercise: Use a Script Library
    • Resource strings
    • Script Library tips
    • Recursion example: Process all child documents
    • Recursion example: Find root parent document
    • Recompile All LotusScript
    • %Include LSS file
  • Topic 30: Custom Classes
    • Custom classes
    • Test the Widget custom class
    • Derived classes (inheritance)
    • Memory management
    • Example: Custom helper class
    • Advantages of object-oriented programming
    • Learn more about custom classes
    • .LSO files
    • .LSX files
  • Topic 31: Server-Based Agents
    • Create a new Agent
    • Trigger (Basics tab)
    • Target (Basics tab)
    • Document selection tab
    • Selecting unprocessed documents
    • Before new mail arrives trigger (Basics tab)
    • Agent security (Security tab)
    • Handling UI method errors in Agents
    • DelayUpdates property for Agents
    • Pass arguments at run time
    • Work queue architecture
    • Agent best practices
  • Topic 32: Agent Logging, Profiling, and Debugging
    • Domino Server Log
    • Private Agent log
    • Custom Agent Log
    • Agent performance and Agent Profiling
    • DDM Application Probes
    • Remote LotusScript Debugger
  • Topic 33: Text File Operations
    • Print to a text file (Output)
    • Read lines from a text file (Input)
    • Read performance
    • Delete a file
    • Example: List Databases to File
    • Exercise: Append to text file
    • Export records to text file
    • Easy comma delimited export
    • Import records from text file
    • NotesStream class
    • Open, write to, and close NotesStream object
    • List databases example
    • Notes converts to MIME in email messages
    • Send MIME/HTML message
  • Topic 34: XML Processing
    • What wont be covered
    • NotesDOMParser and NotesDOMDocumentNode classes
    • Example XML file
    • Walk DOM Tree
    • Exercise: Correlate XML file to walkTree report
    • Create Notes documents from XML
    • Open a NotesStream to a URL
  • Topic 35: Call DLL Procedures
    • Declare DLL procedure
    • Call the DLL Procedure
    • Caveats and tips
    • Win API: GetFolderName
    • Win API: Read/Write INI file
    • Win API: Get registry value
    • Notes C API: Close any Notes window
    • Notes C API: Run file from Notes
    • Other DLL examples
    • Resources
  • Topic 36: Use Other Product Objects
    • Component Object Model (COM)
    • Instantiate product objects
    • Start and stop an application
    • Product object hierarchy
    • Access the object methods and properties
    • Where to find object data files
    • Example 1: Create Excel object from file
    • Example 2: Create new Excel object and set formula
    • Example 3: Create new Excel chart object
    • Example 4: Export View to Excel
    • Example 5: Create new Word object
    • Example 6: Create new Word object (labels)
    • Compound Document Container
    • Example 7: Work with embedded object
    • Notes and OLE
    • Example 8: Create OLE object in PostOpen event handler
    • Troubleshoot OLE problems
    • Example 9: Operate on a detached attachment
    • Windows Script Host (WSH)
    • Windows Management Instrumentation (WMI)
    • Lotus Symphony and COM/OLE
    • IBM Lotus Symphony 3.0 Toolkit
    • Internet Explorer object
    • COM access to Notes objects
    • Buy versus build

Where We Have Trained

We've provided training all over North America and beyond!

Aberdeen, MD Aberdeen, SD Aberdeen, WA Abilene, TX Acton, MA Acworth, GA Ada, OK Addison, IL Adelanto, CA Adrian, MI Agawam, MA Aiken, SC Akron, OH Alabaster, AL Alameda, CA Alamogordo, NM Albany, GA Albany, NY Albany, OR Albert Lea, MN Albertville, AL Albuquerque, NM Alexandria, LA Alexandria, VA Algonquin, IL Alhambra, CA Aliso Viejo, CA Allen, TX Allen Park, MI Allendale, MI Allentown, PA Alliance, NE Alliance, OH Alpharetta, GA Altamonte Springs, FL Alton, IL Altoona, IA Altoona, PA Altus, OK Amarillo, TX American Fork, UT Ames, IA Amesbury, MA Amherst, MA Amherst, NH Amsterdam, NY Anaconda, MT Anacortes, WA Anaheim, CA Anchorage, AK Anderson, IN Anderson, SC Andover, MA Andover, MN Ankeny, IA Ann Arbor, MI Annapolis, MD Anniston, AL Anoka, MN Ansonia, CT Antioch, CA Apache Junction, AZ Apex, NC Apopka, FL Apple Valley, CA Apple Valley, MN Appleton, WI Arcadia, CA Ardmore, OK Arlington, MA Arlington, TX Arlington, WA Arlington Heights, IL Arnold, MO Artesia, NM Arvada, CO Asheboro, NC Asheville, NC Ashland, KY Ashland, MA Ashland, OH Ashland, OR Ashtabula, OH Aspen, CO Atascosa, TX Athens, AL Athens, GA Athens, OH Athens, TN Atlanta, GA Atlantic City, NJ Attleboro, MA Auburn, AL Auburn, IN Auburn, MA Auburn, ME Auburn, NY Auburn, WA Auburn Hills, MI Augusta, GA Augusta, ME Aurora, CO Aurora, IL Aurora, OH Austin, MN Austin, TX Avon, OH Avon Lake, OH Avondale, AZ Avondale Estates, GA Azusa, CA Badger, AK Bainbridge Island, WA Bakersfield, CA Baldwin Park, CA Ballwin, MO Baltimore, MD Bangor, ME Banning, CA Barberton, OH Bardstown, KY Barnegat, NJ Barnstable, MA Barre, VT Barrington, RI Bartlesville, OK Bartlett, IL Bartlett, TN Bartow, FL Batavia, IL Batavia, NY Bath, ME Baton Rouge, LA Battle Creek, MI Battle Ground, WA Bay City, MI Bay Village, OH Bayonne, NJ Bayou Cane, LA Baytown, TX Beacon, NY Beatrice, NE Beaufort, SC Beaumont, CA Beaumont, TX Beaver Dam, WI Beaverton, OR Beckley, WV Bedford, IN Bedford, NH Beech Grove, IN Belgrade, MT Bell Gardens, CA Bella Vista, AR Belle Fourche, SD Belle Glade, FL Belleville, IL Belleville, NJ Bellevue, NE Bellevue, WA Bellflower, CA Bellingham, MA Bellingham, WA Belmont, MA Beloit, WI Belton, MO Belvidere, IL Bend, OR Benton, AR Bentonville, AR Berea, KY Berea, OH Bergenfield, NJ Berkeley, CA Berkeley Heights, NJ Bernardsville, NJ Berwyn, IL Bessemer, AL Bethany, OK Bethel, AK Bethlehem, PA Bettendorf, IA Beulah, ND Beverly, MA Beverly Hills, CA Biddeford, ME Billerica, MA Billings, MT Biloxi, MS Binghamton, NY Birmingham, AL Birmingham, MI Bismarck, ND Bixby, OK Blaine, MN Bloomfield, NJ Bloomfield Hills, MI Bloomington, IL Bloomington, IN Bloomington, MN Blue Springs, MO Bluefield, WV Bluffton, SC Boca Raton, FL Boise, ID Bolingbrook, IL Bonita Springs, FL Bonney Lake, WA Bossier City, LA Boston, MA Bothell, WA Boulder, CO Boulder City, NV Bountiful, UT Bourne, MA Bowie, MD Bowling Green, KY Bowling Green, OH Box Elder, SD Boynton Beach, FL Bozeman, MT Bradenton, FL Braintree, MA Brandon, MS Brandon, SD Brea, CA Brecksville, OH Bremerton, WA Brentwood, CA Brentwood, TN Brewer, ME Brick, NJ Bridgeport, CT Bridgeport, WV Bridgeton, NJ Bridgewater, MA Bridgewater, NJ Brigham City, UT Brighton, CO Brighton, MI Bristol, CT Bristol, RI Bristol, TN Bristol, VA Broadview Heights, OH Brockton, MA Broken Arrow, OK Brookfield, CT Brookfield, WI Brookhaven, MS Brookings, SD Brookline, MA Brooklyn Center, MN Brooklyn Park, MN Brookpark, OH Broomfield, CO Brownsville, TX Brunswick, OH Bryan, TX Buckhead, GA Buena Park, CA Buena Vista, VA Buffalo, MN Buffalo, NY Buffalo Grove, IL Bullhead City, AZ Burbank, CA Burbank, IL Burien, WA Burlington, IA Burlington, MA Burlington, NC Burlington, NJ Burlington, VT Burnsville, MN Burton, MI Butte, MT Byram, MS Byron, MI Cabot, AR Caldwell, ID Calexico, CA Calhoun, GA Calumet City, IL Camarillo, CA Camas, WA Cambridge, MA Cambridge, MD Camden, NJ Campbell, CA Canby, OR Canon City, CO Canton, GA Canton, MA Canton, MI Canton, MS Canton, OH Cape Coral, FL Cape Girardeau, MO Carbondale, IL Caribou, ME Carlsbad, CA Carlsbad, NM Carmel, IN Carol Stream, IL Carpentersville, IL Carrollton, GA Carrollton, TX Carson, CA Carson City, NV Carteret, NJ Cartersville, GA Cary, NC Casa Grande, AZ Casper, WY Casselberry, FL Castle Rock, CO Cathedral City, CA Cayce, SC Cedar City, UT Cedar Falls, IA Cedar Park, TX Cedar Rapids, IA Centerville, OH Centerville, UT Central Falls, RI Central Point, OR Centralia, WA Ceres, CA Cerritos, CA Chalmette, LA Champaign, IL Champlin, MN Chandler, AZ Chanhassen, MN Chaparral, NM Chapel Hill, NC Charleston, SC Charleston, WV Charlotte, NC Charlottesville, VA Chaska, MN Chattanooga, TN Chelmsford, MA Chelsea, MA Chena Ridge, AK Cherry Hill, NJ Chesapeake, VA Chester, PA Chesterfield, MO Cheyenne, WY Chicago, IL Chicago Heights, IL Chickasha, OK Chico, CA Chicopee, MA Chillicothe, OH Chino, CA Chino Hills, CA Chula Vista, CA Cicero, IL Cincinnati, OH Citrus Heights, CA Claremont, CA Claremont, NH Claremore, OK Clarksburg, WV Clarksdale, MS Clarksville, TN Clearfield, UT Clearwater, FL Clemson, SC Clermont, FL Cleveland, MS Cleveland, OH Cleveland, TN Cleveland Heights, OH Cliffside Park, NJ Clifton, NJ Clinton, IA Clinton, MI Clinton, MS Clinton, UT Clive, IA Clovis, CA Clovis, NM Coachella, CA Cocoa, FL Coconut Creek, FL Coeur D Alene, ID Cohoes, NY College, AK College Park, MD College Station, TX Collierville, TN Collinsville, IL Colonial Heights, VA Colorado Springs, CO Colton, CA Columbia, MO Columbia, SC Columbia, TN Columbia Heights, MN Columbus, GA Columbus, IN Columbus, MS Columbus, NE Columbus, OH Commerce City, CO Commerce Township, MI Compton, CA Concord, CA Concord, MA Concord, NC Concord, NH Connersville, IN Conroe, TX Conway, AR Conway, SC Cookeville, TN Coon Rapids, MN Cooper City, FL Coos Bay, OR Coral Gables, FL Coral Springs, FL Coralville, IA Corinth, MS Cornelius, NC Corona, CA Corpus Christi, TX Cortland, NY Corvallis, OR Costa Mesa, CA Cottage Grove, MN Cottonwood Heights, UT Council Bluffs, IA Coventry, RI Covina, CA Covington, GA Covington, KY Covington, VA Covington, WA Cranford, NJ Cranston, RI Crawfordsville, IN Crestview, FL Creve Coeur, MO Crown Point, IN Crystal, MN Crystal Lake, IL Cudahy, WI Culver City, CA Cumberland, MD Cumberland, RI Cupertino, CA Cutler Bay, FL Cuyahoga Falls, OH Cypress, CA Dallas, OR Dallas, TX Dalton, GA Daly City, CA Dana Point, CA Danbury, CT Dania, FL Danvers, MA Danville, CA Danville, IL Danville, KY Danville, VA Daphne, AL Dartmouth, MA Davenport, IA Davie, FL Davis, CA Davison, MI Dayton, OH Daytona Beach, FL De Pere, WI Dearborn, MI Dearborn Heights, MI Decatur, AL Decatur, GA Decatur, IL Dedham, MA Defiance, OH Dekalb, IL Deland, FL Delano, CA Delaware, OH Delray Beach, FL Deltona, FL Deming, NM Denton, TX Denver, CO Derby, CT Derby, KS Derry, NH Des Moines, IA Des Moines, WA Des Plaines, IL Desoto, TX Detroit, MI Devils Lake, ND Diamond Bar, CA Dickinson, ND Dodge City, KS Doral, FL Dothan, AL Douglasville, GA Dover, DE Dover, NH Dowagiac, MI Downers Grove, IL Downey, CA Dracut, MA Draper, UT Dublin, CA Dublin, OH Dubuque, IA Duluth, GA Duluth, MN Dunbar, WV Duncan, OK Dunedin, FL Dunwoody, GA Durango, CO Durant, OK Durham, NC Durham, NH Dyersburg, TN Eagan, MN Eagle, ID Eagle Mountain, UT Easley, SC East Brunswick, NJ East Chicago, IN East Cleveland, OH East Lansing, MI East Orange, NJ East Providence, RI East Ridge, TN East Saint Louis, IL Easthampton, MA Eastlake, OH Easton, MA Easton, PA Eastpointe, MI Eau Claire, WI Eden Prairie, MN Edina, MN Edinburg, TX Edison, NJ Edmond, OK Edmonds, WA Edwardsville, IL Egg Harbor Township, NJ El Cajon, CA El Centro, CA El Dorado, KS El Mirage, AZ El Monte, CA El Paso, TX El Reno, OK Eldorado, TX Elgin, IL Elizabeth, NJ Elizabethton, TN Elizabethtown, KY Elk Grove, CA Elk Grove Village, IL Elk River, MN Elkhart, IN Elko, NV Ellensburg, WA Elmhurst, IL Elmira, NY Elmwood Park, IL Elyria, OH Emporia, KS Emporia, VA Encinitas, CA Englewood, CO Englewood, NJ Enid, OK Enterprise, AL Erie, CO Erie, PA Erlanger, KY Escondido, CA Euclid, OH Eugene, OR Euless, TX Evans, CO Evans, GA Evanston, IL Evanston, WY Evansville, IN Everett, MA Everett, WA Ewa Beach, HI Ewa Gentry, HI Exeter, NH Fair Lawn, NJ Fairbanks, AK Fairborn, OH Fairfax, VA Fairfield, CA Fairfield, OH Fairmont, WV Fairview Park, OH Fall River, MA Fallon, NV Falls Church, VA Falmouth, MA Fargo, ND Faribault, MN Farmington, MI Farmington, MN Farmington, MO Farmington, NM Farmington, UT Farragut, TN Fayetteville, AR Fayetteville, GA Fayetteville, NC Federal Way, WA Fenton, MI Ferndale, MI Fernley, NV Findlay, OH Fitchburg, MA Fitchburg, WI Flagstaff, AZ Flint, MI Florence, AL Florence, AZ Florence, KY Florence, SC Florissant, MO Flower Mound, TX Flushing, MI Folsom, CA Fond Du Lac, WI Fontana, CA Forest Grove, OR Forest Hills, MI Forest Lake, MN Forest Park, OH Fort Benning, GA Fort Collins, CO Fort Dodge, IA Fort Lauderdale, FL Fort Lee, NJ Fort Mill, SC Fort Myers, FL Fort Pierce, FL Fort Smith, AR Fort Thomas, KY Fort Walton Beach, FL Fort Wayne, IN Fort Worth, TX Fountain, CO Fountain Hills, AZ Fountain Valley, CA Foxboro, MA Framingham, MA Frankfort, IN Frankfort, KY Franklin, IN Franklin, MA Franklin, NJ Franklin, TN Franklin, VA Franklin, WI Frederick, MD Fredericksburg, VA Freehold, NJ Freeport, IL Fremont, CA Fremont, NE Fremont, OH Fresno, CA Fridley, MN Frisco, TX Fruita, CO Fullerton, CA Gadsden, AL Gaffney, SC Gahanna, OH Gaines, MI Gainesville, FL Gainesville, GA Gaithersburg, MD Galax, VA Galesburg, IL Gallatin, TN Gallup, NM Garden City, KS Garden City, MI Garden Grove, CA Gardena, CA Gardner, KS Gardner, MA Garfield, NJ Garfield Heights, OH Garland, TX Garner, NC Gary, IN Gastonia, NC Gautier, MS Georgetown, DE Georgetown, KY Georgetown, TX Gering, NE Germantown, TN Gilbert, AZ Gillette, WY Gilroy, CA Glasgow, KY Glen Cove, NY Glen Ellyn, IL Glen Falls, NY Glendale, AZ Glendale, CA Glendale Heights, IL Glendora, CA Glenview, IL Glenwood Springs, CO Gloucester, MA Gloucester City, NJ Gloversville, NY Goffstown, NH Golden, CO Golden Valley, MN Goldsboro, NC Goleta, CA Goodlettsville, TN Goodyear, AZ Goose Creek, SC Goshen, IN Grafton, MA Grafton, ND Grand Blanc, MI Grand Forks, ND Grand Haven, MI Grand Island, NE Grand Junction, CO Grand Prairie, TX Grand Rapids, MI Grandview, MO Grandville, MI Granite City, IL Grants Pass, OR Great Bend, KS Great Falls, MT Greeley, CO Green Bay, WI Green River, WY Greenacres, FL Greenbelt, MD Greencastle, IN Greeneville, TN Greenfield, IN Greenfield, MA Greenfield, WI Greensboro, NC Greensburg, IN Greensburg, PA Greenville, MI Greenville, MS Greenville, NC Greenville, SC Greenwood, IN Greenwood, MS Greenwood, SC Greer, SC Grenada, MS Gresham, OR Gretna, LA Griffin, GA Grosse Ile, MI Grosse Pointe, MI Groton, CT Grove City, OH Gulfport, MS Gurnee, IL Hackensack, NJ Hagerstown, MD Haines City, FL Halawa, HI Hallandale, FL Ham Lake, MN Hamilton, NJ Hamilton, OH Hammond, IN Hammond, LA Hampton, CT Hampton, NH Hampton, VA Hamtramck, MI Hanahan, SC Hanford, CA Hannibal, MO Hanover, NH Happy Valley, OR Harlingen, TX Harrisburg, PA Harrison, MI Harrison Township, MI Harrisonburg, VA Hartford, CT Hartford, WI Harvey, IL Harvey, LA Haslett, MI Hastings, MN Hastings, NE Hattiesburg, MS Havelock, NC Haverhill, MA Havre, MT Havre De Grace, MD Hawthorne, CA Hays, KS Hayward, CA Hazel Park, MI Hazelwood, MO Hazlet, NJ Hazleton, PA Helena, MT Hemet, CA Henderson, KY Henderson, NV Hendersonville, TN Hermiston, OR Hermitage, PA Hernando, MS Herriman, UT Hesperia, CA Hialeah, FL Hibbing, MN Hickory, NC High Point, NC Highland, CA Highland, MI Highland, UT Highland Park, IL Highland Park, MI Hilliard, OH Hillsboro, OR Hillsborough, NJ Hillside, NJ Hilo, HI Hilton Head Island, SC Hinesville, GA Hingham, MA Hobart, IN Hobbs, NM Hoboken, NJ Hoffman Estates, IL Holden, MA Holladay, UT Holland, MI Hollister, CA Holly Springs, NC Hollywood, FL Holt, MI Holyoke, MA Homer Glen, IL Homestead, FL Honolulu, HI Hooksett, NH Hoover, AL Hopewell, VA Hopkins, MN Hopkinsville, KY Horn Lake, MS Hot Springs Village, AR Houma, LA Houston, TX Howell, NJ Huber Heights, OH Hudson, MA Hudson, NH Hudson, OH Huntersville, NC Huntington, IN Huntington, WV Huntington Beach, CA Huntington Park, CA Huntley, IL Huntsville, AL Huron, SD Hurricane, UT Hutchinson, KS Hutchinson, MN Hyattsville, MD Idaho Falls, ID Independence, KY Independence, MO Indian Trail, NC Indianapolis, IN Indianola, IA Indio, CA Inglewood, CA Inkster, MI Inver Grove Heights, MN Iowa City, IA Irmo, SC Irvine, CA Irving, TX Irvington, NJ Issaquah, WA Ithaca, NY Jackson, MI Jackson, MS Jackson, NJ Jackson, TN Jackson, WY Jacksonville, AR Jacksonville, FL Jacksonville, NC Jacksonville Beach, FL Jamestown, ND Jamestown, NY Janesville, WI Jasper, IN Jefferson City, MO Jeffersonville, IN Jeffersonville, KY Jenison, MI Jenks, OK Jersey City, NJ Johns Creek, GA Johnson City, TN Johnston, IA Johnston, RI Johnstown, PA Joliet, IL Jonesboro, AR Joplin, MO Junction City, KS Juneau, AK Jupiter, FL Kahului, HI Kailua, HI Kalamazoo, MI Kalifornsky, AK Kalispell, MT Kaneohe, HI Kankakee, IL Kannapolis, NC Kansas City, KS Kansas City, MO Kapolei, HI Kaukauna, WI Kaysville, UT Kearney, NE Kearny, NJ Keene, NH Keizer, OR Kenai, AK Kenmore, WA Kenner, LA Kennesaw, GA Kennewick, WA Kenosha, WI Kent, OH Kent, WA Kernersville, NC Ketchikan, AK Kettering, OH Key West, FL Kihei, HI Killeen, TX Kingman, AZ Kingsport, TN Kingston, NY Kinston, NC Kirkland, WA Kirksville, MO Kissimmee, FL Klamath Falls, OR Knik-Fairview, AK Knoxville, TN Kodiak, AK Kokomo, IN Kuna, ID La Crosse, WI La Grande, OR La Habra, CA La Mesa, CA La Mirada, CA La Place, LA La Porte, IN La Puente, CA La Quinta, CA La Vergne, TN La Verne, CA La Vista, NE Lacey, WA Lackawanna, NY Laconia, NH Lafayette, CO Lafayette, IN Lafayette, LA Lagrange, GA Laguna Hills, CA Laguna Niguel, CA Lake Charles, LA Lake Elsinore, CA Lake Forest, CA Lake Havasu City, AZ Lake In The Hills, IL Lake Oswego, OR Lake Saint Louis, MO Lake Station, IN Lake Stevens, WA Lake Worth, FL Lakeland, FL Lakeville, MN Lakewood, CA Lakewood, NJ Lakewood, OH Lakewood, WA Lancaster, CA Lancaster, OH Lancaster, PA Lansing, IL Lansing, MI Lapeer, MI Laramie, WY Laredo, TX Largo, FL Las Cruces, NM Las Vegas, NM Las Vegas, NV Lauderhill, FL Laurel, MD Laurel, MS Laurel, MT Lawndale, CA Lawrence, IN Lawrence, KS Lawrence, MA Lawrence Township, NJ Lawrenceville, GA Lawton, OK Layton, UT League City, TX Leavenworth, KS Leawood, KS Lebanon, IN Lebanon, MO Lebanon, NH Lebanon, OH Lebanon, OR Lebanon, PA Lebanon, TN Lees Summit, MO Leesburg, FL Lehi, UT Lenexa, KS Leominster, MA Lewiston, ID Lewiston, ME Lewistown, MT Lewisville, TX Lexington, KY Lexington, MA Lexington, NE Lexington, SC Lexington, VA Liberal, KS Liberty, MO Lima, OH Lincoln, CA Lincoln, NE Lincoln, RI Lincoln Park, MI Linden, NJ Lino Lakes, MN Lithia Springs, GA Little Rock, AR Littleton, CO Livermore, CA Livingston, MT Livingston, NJ Livonia, MI Lockport, IL Lockport, NY Lodi, CA Lodi, NJ Logan, UT Logansport, IN Lombard, IL Lompoc, CA Londonderry, NH Long Beach, CA Long Beach, MS Long Beach, NY Long Branch, NJ Longmont, CO Longview, TX Longview, WA Lookout Mountain, GA Lorain, OH Los Alamos, NM Los Angeles, CA Los Banos, CA Los Gatos, CA Los Lunas, NM Louisville, CO Louisville, KY Loveland, CO Lovington, NM Lowell, MA Lowell, MI Lubbock, TX Ludington, MI Ludlow, MA Lumberton, NC Lynchburg, VA Lyndhurst, NJ Lynn, MA Lynn Haven, FL Lynnwood, WA Lynwood, CA Mableton, GA Macomb, MI Macon, GA Madera, CA Madison, AL Madison, IN Madison, MS Madison, SD Madison, WI Madison Heights, MI Madisonville, KY Mahwah, NJ Maitland, FL Makakilo, HI Malden, MA Manassas, VA Manchester, MO Manchester, NH Manchester Township, NJ Mandan, ND Manhattan, KS Manhattan Beach, CA Manistee, MI Manitowoc, WI Mankato, MN Mansfield, MA Mansfield, OH Mansfield, TX Manteca, CA Maple Grove, MN Maple Heights, OH Maple Valley, WA Maplewood, NJ Marana, AZ Margate, FL Maricopa, AZ Marietta, GA Marietta, OH Marion, IA Marion, IN Marion, OH Marlboro, NJ Marlborough, MA Marquette, MI Marrero, LA Marshalltown, IA Marshfield, MA Marshfield, WI Martinez, CA Martinsburg, WV Martinsville, IN Martinsville, VA Maryland Heights, MO Marysville, OH Marysville, WA Maryville, TN Mason, OH Mason City, IA Massillon, OH Matthews, NC Mauldin, SC Maumee, OH Mayfield Heights, OH Mcalester, OK Mcallen, TX Mcdonough, GA Mchenry, IL Mckeesport, PA Mckinney, TX Mcminnville, OR Mcpherson, KS Meadow Lakes, AK Medford, MA Medford, NJ Medford, OR Medina, OH Melbourne, FL Melrose, MA Melrose Park, IL Memphis, TN Menasha, WI Menifee, CA Menlo Park, CA Menomonie, WI Mentor, OH Mequon, WI Merced, CA Mercer Island, WA Meriden, CT Meridian, ID Meridian, MS Merrimack, NH Mesquite, NV Mesquite, TX Metairie, LA Methuen, MA Miami, FL Miami, OK Miami Beach, FL Miami Gardens, FL Miamisburg, OH Michigan City, IN Middleboro, MA Middleburg Heights, OH Middleton, WI Middletown, CT Middletown, DE Middletown, NJ Middletown, NY Middletown, OH Middletown, RI Midland, MI Midland, TX Midvale, UT Midwest City, OK Miles City, MT Milford, CT Milford, DE Milford, MA Milford, MI Milford, NH Mililani, HI Mililani Mauka, HI Mill Creek, WA Millburn, NJ Millville, NJ Milpitas, CA Milton, GA Milton, MA Milwaukee, WI Minneapolis, MN Minnetonka, MN Minot, ND Mint Hill, NC Miramar Beach, FL Mishawaka, IN Mission, TX Mission Viejo, CA Missoula, MT Missouri City, TX Mitchell, SD Mobile, AL Modesto, CA Moline, IL Monroe, LA Monroe, MI Monroe, NC Monroe, WA Monroe Township, NJ Monrovia, CA Montclair, CA Montclair, NJ Montebello, CA Monterey Park, CA Montgomery, AL Monticello, FL Montpelier, VT Montrose, CO Montville, NJ Moore, OK Moore Haven, FL Moorestown, NJ Mooresville, NC Moorhead, MN Moorpark, CA Moreno Valley, CA Morgan Hill, CA Morgantown, WV Morristown, NJ Morristown, TN Moscow, ID Moses Lake, WA Moss Point, MS Moundsville, WV Mount Clemens, MI Mount Laurel, NJ Mount Morris, MI Mount Pleasant, MI Mount Pleasant, SC Mount Prospect, IL Mount Rainier, MD Mount Vernon, NY Mount Vernon, OH Mount Vernon, WA Mountain Brook, AL Mountain Home, ID Mountain View, CA Mountlake Terrace, WA Mukilteo, WA Muncie, IN Mundelein, IL Murfreesboro, TN Murray, KY Murray, UT Murrieta, CA Muscatine, IA Muskego, WI Muskegon, MI Muskogee, OK Mustang, OK Myrtle Beach, SC Nampa, ID Napa, CA Naperville, IL Naples, FL Narragansett, RI Nashua, NH Nashville, TN Natchez, MS Natchitoches, LA Natick, MA National City, CA Needham, MA Neenah, WI Neptune, NJ New Albany, IN New Bedford, MA New Berlin, WI New Bern, NC New Braunfels, TX New Brighton, MN New Britain, CT New Brunswick, NJ New Castle, DE New Castle, IN New Castle, PA New Franklin, OH New Hartford, CT New Haven, CT New Haven, IN New Hope, MN New Iberia, LA New Lenox, IL New London, CT New Orleans, LA New Philadelphia, OH New Rochelle, NY New Smyrna Beach, FL New York, NY Newark, CA Newark, DE Newark, NJ Newark, OH Newberg, OR Newburgh, NY Newburyport, MA Newnan, GA Newport, KY Newport, RI Newport, VT Newport Beach, CA Newport News, VA Newton, IA Newton, KS Newton, MA Niagara Falls, NY Nicholasville, KY Niles, IL Niles, MI Niles, OH Nixa, MO Noblesville, IN Norfolk, CT Norfolk, NE Norfolk, VA Normal, IL Norman, OK North Andover, MA North Attleboro, MA North Augusta, SC North Bergen, NJ North Brunswick, NJ North Canton, OH North Charleston, SC North Chicago, IL North Fort Myers, FL North Haven, CT North Kingstown, RI North Las Vegas, NV North Lauderdale, FL North Little Rock, AR North Miami Beach, FL North Myrtle Beach, SC North Ogden, UT North Olmsted, OH North Platte, NE North Port, FL North Providence, RI North Richland Hills, TX North Ridgeville, OH North Royalton, OH North Salt Lake, UT North Tonawanda, NY Northampton, MA Northbrook, IL Northfield, MN Northport, AL Northville, MI Norton, MA Norton, VA Norwalk, CA Norwalk, CT Norwalk, OH Norwich, CT Norwood, MA Norwood, OH Novato, CA Novi, MI Nutley, NJ O Fallon, IL O Fallon, MO Oak Creek, WI Oak Forest, IL Oak Harbor, WA Oak Lawn, IL Oak Park, IL Oak Park, MI Oak Ridge, TN Oakdale, MN Oakland, CA Oakland, MI Oakland Park, FL Oakley, CA Ocala, FL Ocean City, NJ Ocean Springs, MS Oceanside, CA Ocoee, FL Oconomowoc, WI Odessa, TX Ogden, UT Okemos, MI Oklahoma City, OK Olathe, KS Old Bridge, NJ Olean, NY Olive Branch, MS Olympia, WA Omaha, NE Onalaska, WI Ontario, CA Opelika, AL Opelousas, LA Orange, CA Orange, NJ Orangeburg, SC Oregon, OH Oregon City, OR Orem, UT Orland Park, IL Orlando, FL Ormond Beach, FL Oshkosh, WI Oswego, IL Oswego, NY Ottawa, KS Ottumwa, IA Overland Park, KS Oviedo, FL Owasso, OK Owatonna, MN Owensboro, KY Owosso, MI Oxford, AL Oxford, MI Oxford, MS Oxford, OH Oxnard, CA Ozark, MO Pacifica, CA Paducah, KY Painesville, OH Palatine, IL Palm Bay, FL Palm Beach, FL Palm Beach Gardens, FL Palm Coast, FL Palm Desert, CA Palm Springs, CA Palmdale, CA Palmer, AK Palo Alto, CA Panama City, FL Papillion, NE Paragould, AR Paramount, CA Paramus, NJ Park Ridge, IL Parker, CO Parkersburg, WV Parma, OH Parsippany, NJ Pasadena, CA Pasadena, TX Pascagoula, MS Pasco, WA Paso Robles, CA Passaic, NJ Pataskala, OH Paterson, NJ Pawtucket, RI Payson, UT Peabody, MA Peachtree City, GA Pearl, MS Pearl City, HI Pearland, TX Peekskill, NY Pekin, IL Pelham, AL Pelham, NH Pemberton, NJ Pembroke, MA Pembroke Pines, FL Pendleton, OR Pennsauken, NJ Pensacola, FL Pentwater, MI Peoria, AZ Peoria, IL Perris, CA Perrysburg, OH Perth Amboy, NJ Peru, IN Petaluma, CA Petersburg, VA Pflugerville, TX Pharr, TX Phenix City, AL Philadelphia, PA Phoenix, AZ Pickerington, OH Pico Rivera, CA Pierre, SD Pine Bluff, AR Pinellas Park, FL Piqua, OH Piscataway, NJ Pittsburg, CA Pittsburg, KS Pittsburgh, PA Pittsfield, MA Placentia, CA Plainfield, IL Plainfield, NJ Plainsboro, NJ Plano, TX Plant City, FL Plantation, FL Plattsburgh, NY Pleasant Grove, UT Pleasant Hill, CA Pleasantville, NJ Plymouth, CT Plymouth, IN Plymouth, MA Plymouth, MI Plymouth, MN Pocatello, ID Pomona, CA Pompano Beach, FL Ponca City, OK Pontiac, MI Pooler, GA Poplar Bluff, MO Poquoson, VA Port Angeles, WA Port Arthur, TX Port Huron, MI Port Orange, FL Port Royal, SC Port Saint Lucie, FL Portage, IN Portage, MI Portales, NM Porterville, CA Portland, ME Portland, OR Portsmouth, NH Portsmouth, OH Portsmouth, RI Portsmouth, VA Post Falls, ID Pottsville, PA Poughkeepsie, NY Poway, CA Powder Springs, GA Prairie Village, KS Prairieville, LA Prattville, AL Prescott, AZ Prescott Valley, AZ Presque Isle, ME Prichard, AL Princeton, NJ Prior Lake, MN Prospect, CT Providence, RI Provo, UT Pueblo, CO Pullman, WA Puyallup, WA Queen Creek, AZ Quincy, IL Quincy, MA Racine, WI Radcliff, KY Radford, VA Raleigh, NC Ramsey, MN Ramsey, NJ Rancho Cordova, CA Rancho Palos Verdes, CA Rancho Santa Margarita, CA Randolph, MA Randolph, NJ Rapid City, SD Raritan, NJ Raymore, MO Raytown, MO Reading, MA Reading, PA Red Wing, MN Redan, GA Redding, CA Redford, MI Redlands, CA Redmond, OR Redmond, WA Redondo Beach, CA Redwood City, CA Reno, NV Renton, WA Republic, MO Revere, MA Rexburg, ID Reynoldsburg, OH Rialto, CA Richardson, TX Richfield, MN Richland, WA Richmond, CA Richmond, IN Richmond, KY Richmond, VA Ridgeland, MS Ridgewood, NJ Rio Rancho, NM River Falls, WI Riverside, CA Riverside, CT Riverton, UT Riverton, WY Riviera Beach, FL Roanoke, VA Rochester, MI Rochester, MN Rochester, NH Rochester, NY Rock Hill, SC Rock Island, IL Rock Springs, WY Rockaway, NJ Rockford, IL Rockland, MA Rockledge, FL Rocklin, CA Rockville, MD Rocky Mount, NC Rocky River, OH Rogers, AR Rohnert Park, CA Rolla, MO Rolling Meadows, IL Rome, GA Rome, NY Romeoville, IL Romulus, MI Roseburg, OR Roselle, NJ Rosemead, CA Rosemount, MN Roseville, CA Roseville, MI Roseville, MN Roswell, GA Roswell, NM Round Lake, IL Round Rock, TX Rowlett, TX Roy, UT Royal Kunia, HI Royal Oak, MI Russellville, AR Ruston, LA Rutland, VT Rye, NY Saco, ME Sacramento, CA Saginaw, MI Sahuarita, AZ Saint Albans, VT Saint Albans, WV Saint Charles, IL Saint Charles, MO Saint Clair, MI Saint Clair Shores, MI Saint Cloud, FL Saint Cloud, MN Saint George, UT Saint Helens, OR Saint Joseph, MO Saint Louis, MO Saint Louis Park, MN Saint Michael, MN Saint Paul, MN Saint Peters, MO Saint Petersburg, FL Salem, CT Salem, MA Salem, NH Salem, OR Salem, VA Salina, KS Salinas, CA Salisbury, MD Salisbury, NC Salt Lake City, UT Sammamish, WA San Angelo, TX San Antonio, TX San Bernardino, CA San Bruno, CA San Clemente, CA San Diego, CA San Dimas, CA San Francisco, CA San Gabriel, CA San Jacinto, CA San Jose, CA San Juan Capistrano, CA San Leandro, CA San Luis Obispo, CA San Marcos, CA San Marcos, TX San Mateo, CA San Rafael, CA San Ramon, CA Sand Springs, OK Sandusky, OH Sandwich, MA Sandy, UT Sandy Springs, GA Sanford, FL Sanford, ME Sanford, NC Santa Ana, CA Santa Barbara, CA Santa Clara, CA Santa Clarita, CA Santa Cruz, CA Santa Fe, NM Santa Maria, CA Santa Monica, CA Santa Paula, CA Santa Rosa, CA Santee, CA Sapulpa, OK Sarasota, FL Saratoga, CA Saratoga Springs, NY Saratoga Springs, UT Sartell, MN Saugus, MA Savage, MN Savannah, GA Sayreville, NJ Schaumburg, IL Schenectady, NY Schofield Barracks, HI Scituate, MA Scotch Plains, NJ Scottsbluff, NE Scottsdale, AZ Scottville, MI Scranton, PA Seaford, DE Searcy, AR Seaside, CA SeaTac, WA Seattle, WA Sebastian, FL Sebring, FL Sedalia, MO Selma, AL Seymour, IN Shaker Heights, OH Shakopee, MN Sharon, MA Sharon, PA Shawnee, KS Shawnee, OK Sheboygan, WI Shelby, MI Shelby, NC Shelbyville, IN Shelbyville, KY Shelbyville, MI Shelbyville, TN Shelton, CT Shenandoah, LA Sheridan, WY Sherwood, AR Sherwood, OR Shoreline, WA Shoreview, MN Shreveport, LA Shrewsbury, MA Sidney, MT Sidney, OH Sierra Vista, AZ Sikeston, MO Simi Valley, CA Simpsonville, SC Sioux City, IA Sioux Falls, SD Sitka, AK Skokie, IL Slidell, LA Smithfield, RI Smyrna, DE Smyrna, GA Smyrna, TN Solon, OH Somerset, MA Somersworth, NH Somerville, MA South Bend, IN South Burlington, VT South Euclid, OH South Gate, CA South Hadley, MA South Jordan, UT South Kingstown, RI South Milwaukee, WI South Ogden, UT South Plainfield, NJ South Portland, ME South Saint Paul, MN South Salt Lake, UT South San Francisco, CA South Sioux City, NE South Valley, NM Southaven, MS Southbridge, MA Southfield, MI Southgate, MI Southport, CT Spanish Fork, UT Sparks, NV Sparta, NJ Spartanburg, SC Spearfish, SD Spokane, WA Spokane Valley, WA Spring, TX Springboro, OH Springdale, AR Springfield, IL Springfield, MA Springfield, MO Springfield, OH Springfield, OR Springfield, TN Springville, UT Stamford, CT Stanton, CA Starkville, MS Statesboro, GA Statesville, NC Staunton, VA Steamboat Springs, CO Steele Creek, AK Sterling, AK Sterling, CO Sterling Heights, MI Steubenville, OH Stevens Point, WI Stillwater, MN Stillwater, OK Stockbridge, GA Stockton, CA Stoneham, MA Stoughton, MA Stow, OH Streamwood, IL Streetsboro, OH Strongsville, OH Sturgis, SD Sudbury, MA Suffolk, VA Sugar Land, TX Sulphur, LA Summerville, SC Summit, NJ Sumter, SC Sun Prairie, WI Sunland Park, NM Sunnyside, WA Sunnyvale, CA Sunrise, FL Superior, WI Surprise, AZ Swartz Creek, MI Sylvania, OH Syracuse, NY Syracuse, UT Tacoma, WA Tahlequah, OK Takoma Park, MD Tallahassee, FL Tallmadge, OH Tampa, FL Tanaina, AK Tarpon Springs, FL Taunton, MA Taylor, MI Taylorsville, UT Teaneck, NJ Temecula, CA Tempe, AZ Temple, TX Temple City, CA Terre Haute, IN Terrytown, LA Tewksbury, MA Texarkana, AR The Dalles, OR Thibodaux, LA Thomasville, NC Thornton, CO Thousand Oaks, CA Tiffin, OH Tifton, GA Tigard, OR Tinley Park, IL Tiverton, RI Toledo, OH Toms River, NJ Tonawanda, NY Tooele, UT Topeka, KS Torrance, CA Torrington, CT Tracy, CA Traverse City, MI Trenton, MI Trenton, NJ Troutdale, OR Troy, AL Troy, MI Troy, NY Troy, OH Trussville, AL Tualatin, OR Tucker, GA Tucson, AZ Tukwila, WA Tulare, CA Tullahoma, TN Tulsa, OK Tumwater, WA Tupelo, MS Turlock, CA Tuscaloosa, AL Tustin, CA Twin Falls, ID Twinsburg, OH Tybee Island, GA Tyler, TX Union, NJ Union City, CA Union City, NJ University Place, WA Upland, CA Upper Arlington, OH Urbana, IL Urbandale, IA Utica, NY Vacaville, CA Valdosta, GA Vallejo, CA Valley City, ND Valparaiso, IN Van Buren, AR Vancouver, WA Vandalia, OH Venice, FL Ventura, CA Vergennes, VT Vermillion, SD Vernon, NJ Vernon Hills, IL Vero Beach, FL Vestavia Hills, AL Vicksburg, MS Victoria, TX Victorville, CA Vidalia, GA Vienna, WV Villa Rica, GA Vincennes, IN Vineland, NJ Virginia Beach, VA Visalia, CA Vista, CA Voorhees, NJ Wabash, IN Waco, TX Wadsworth, OH Wahiawa, HI Wahpeton, ND Wailuku, HI Waipahu, HI Wake Forest, NC Wakefield, MA Walla Walla, WA Walnut, CA Walnut Creek, CA Walpole, MA Waltham, MA Wareham, MA Warner Robins, GA Warren, MI Warren, OH Warrensburg, MO Warsaw, IN Warwick, RI Washington, DC Washington, IN Washington, MI Washington, NJ Washington, PA Washington, UT Washington Court House, OH Washougal, WA Wasilla, AK Waterbury, CT Waterford, CT Waterford, MI Waterloo, IA Watertown, MA Watertown, NY Watertown, SD Watertown, WI Waterville, ME Watsonville, CA Waukegan, IL Waukesha, WI Wausau, WI Wauwatosa, WI Waycross, GA Wayne, MI Wayne, NJ Waynesboro, GA Waynesboro, VA Webster, MA Webster Groves, MO Weirton, WV Wellesley, MA Wellington, FL Wenatchee, WA Wentzville, MO West Allis, WI West Bend, WI West Bloomfield, MI West Chicago, IL West Columbia, SC West Covina, CA West Deptford, NJ West Des Moines, IA West Fargo, ND West Haven, CT West Hollywood, CA West Jordan, UT West Lafayette, IN West Linn, OR West Memphis, AR West Milford, NJ West Monroe, LA West New York, NJ West Orange, NJ West Palm Beach, FL West Sacramento, CA West Saint Paul, MN West Springfield, MA West Warwick, RI Westborough, MA Westbrook, ME Westerly, RI Westerville, OH Westfield, IN Westfield, MA Westfield, NJ Westford, MA Westlake, OH Westland, MI Westminster, CA Westminster, CO Westminster, MD Westmont, IL Weston, FL Westport, CT Weymouth, MA Wheat Ridge, CO Wheaton, IL Wheeling, IL Wheeling, WV White Bear Lake, MN White Lake, MI White Plains, NY Whitefish, MT Whitehall, OH Whitewater, WI Whittier, CA Wichita, KS Wichita Falls, TX Wildomar, CA Wildwood, MO Wilkes Barre, PA Williamsburg, VA Williamsport, PA Willingboro, NJ Williston, ND Willmar, MN Willoughby, OH Willowick, OH Wilmette, IL Wilmington, DE Wilmington, MA Wilmington, NC Wilson, NC Wilsonville, OR Winchester, KY Winchester, MA Winchester, VA Windham, NH Windsor, CO Windsor, CT Winfield, KS Winnemucca, NV Winona, MN Winooski, VT Winsted, CT Winston Salem, NC Winter Garden, FL Winter Haven, FL Winter Park, FL Winter Springs, FL Winthrop, MA Wisconsin Rapids, WI Woburn, MA Woodbridge, NJ Woodburn, OR Woodbury, CT Woodbury, MN Woodland, CA Woodridge, IL Woodstock, GA Woodstock, IL Woonsocket, RI Wooster, OH Worcester, MA Worthington, OH Wyandotte, MI Wyoming, MI Xenia, OH Yakima, WA Yankton, SD Yarmouth Port, MA Yonkers, NY Yorba Linda, CA York, PA Youngstown, OH Ypsilanti, MI Yuba City, CA Yucaipa, CA Yukon, OK Yuma, AZ Zachary, LA Zanesville, OH Zephyrhills, FL Zion, IL